Working on a dashboard in ArcGIS online. My aim is to create a list-like element in the dashboard that displays the sum of one field, rolled up on (grouped by) another field. I've seen a similar example from the community for getting this to work in a popup (e.g. https://community.esri.com/t5/developers-questions/how-to-use-arcade-groupby-with-top-and-orderby/td...) but I would like this content to be calculated based on the current extent of the map display in the dashboard.
If I approach it by first creating a data expression FeatureSet, I (apparently?) lose the ability to filter that FeatureSet to match the current view extent. (No exposed Globals in the Dashboard Data Arcade Profile)
If instead I try to create an expression in the advanced formatting interface of either the indicator or list element, I lose the ability to execute a "GroupBy" function.
Referencing the clinic example linked above, is there an alternative approach to "GroupBy" that would work to sum up patients by facility name based on map extent, rather than a popup after clicking a polygon?
Or is there some other way to add an arcade expression to a dashboard that I am missing?
Thanks,
Andrew