Hi all!
I'm building an app in ArcGIS Experience Builder that displays a pie chart of population breakdown by race and ethnicity across the Richmond, VA metro area using ACS 5-year estimates (2006–2023).
My data structure:
- One row per census tract per ACS period (e.g., tract 1001 has a row for 2006, 2007, 2008, etc.)
- Each row contains population counts for 8 mutually exclusive race/ethnicity fields
- The feature layer is time-enabled using a date field called `acs_startnew`
- The map widget is already responding correctly to the time slider
What I'm trying to do:
I want the pie chart to dynamically update its summed values to match whichever ACS time period the map is currently showing. So when the map displays 2009 data, the chart should sum tract-level values only for rows where `acs_startnew = 2009`.
What I'm having trouble with:
I've tried connecting the chart to Map 22 via Message Actions (Action tab → Add a trigger → Map 22 → Filter), but the chart doesn't appear to be filtering correctly. It seems like the Sum statistic is aggregating across all years rather than just the active time period.
1. Is "Filter" the correct message action to link a chart widget to a time-enabled map?
2. Does the chart's data source need to be connected directly to the feature layer (rather than sourced through the map) for the filter to apply correctly?
3. Is there a recommended pattern for keeping a chart and a time-enabled map synchronized in Experience Builder?
Any guidance appreciated, thanks in advance!
