Multiple data filters and indicators may help on a dashboard, a little clunky for what you are describing, but has worked for me before on projects with multiple inputs and with the new data download you can get CSV's from hosted feature layer data that can be filtered. I would definitely recommend trying @jcarlson 's suggestion though, I probably will. Data expressions have been a topic I have heard about for years and am glad everything is coming together nicely. If you're still having trouble and you can't find an answer, I would suggest reaching out to ESRI's support teams or tech support. They've been able to walk me through projects on a number of occasions and are always most helpful and resourceful when it comes to these things.
Hope this helps @3CDCOrganizationalAccount ,
God bless,
Jansen Lyons - Records and GIS Section - Public Works - City of Rio Rancho, NM