I'm not even sure if this is possible but here it goes. I have data for opioid prescriptions in my state by county and year. My end goal is to have a choropleth (filled) web map with time enabled embedded into an Operations Dashboard. I would like the user to be able to use the date selector to visualize the data by county over their specified time period. The problem I am having is that when I use the date selector I cannot see an aggregate if i select multiple years.
So my question: is it possible to write a custom ArcGIS Arcade expression that will select the field "2015-2017sum" if the date range entered is 2015 through 2017? I have virtually no experience with Arcade so I am unsure how to even go about testing my theory. Thank you!