Formatting/structuring attribute data for a Dashboard Serial Chart

[AlexWolf1]

Hello there,

I'm just getting started in Dashboards and have what seems like a simple question - I suspect my inability to find an answer is not having the right keywords to search.

I'd like users to select a polygon (either click on a map or use the Dashboard selector dropdown), and have annual series data displayed in a series graph.  Think census population of a county over a few decades - user clicks on a county, they can see how the population has changed over time in the graph below.  What I can't figure out is how to structure the attribute table - it seems like each polygon should get one row in order for a user to be able to select it, with field names like 'Pop1990' and 'Pop2020', but I can't quite figure out how to set up the Serial Chart with that 'wide' format.  Any resources on data structure and Serial charts would be appreciated.  Thanks!

[AndreasHall · Accepted solution]

The attribute table structure you mention should work. Just create your categories from fields: Data series—ArcGIS Dashboards | Documentation.

Another solution would be to separate the polygons and the time series into different tables. Then the time series could be such that there is one row for each polygon and time step. Selecting a polygon in the map could be configured so that it filters an serial chart created from the other table based on an ID. 

[AlexWolf1]

Thanks for the reply, Andreas.  The first solution worked, but I could see utility in the second suggestion - is there more documentation to help me figure that out?

[AndreasHall]

You can try to use this data schema (features) for the time series, just add a column for year. On the map, configure a Layer action on the polygon layer that filters the serial chart based on name/ID. Tick Render only when filtered if you want it to only show data after a selection is made in the map.