nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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!

Find more posts tagged with

ArcGIS Online

Accepted answers

AndreasHall

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.

All comments

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.

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

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.