I am trying to display state-level symbology information using data structured as follows:
State | Number of Household Members | Family ID |
North Carolina | 3 | a |
North Carolina | 1 | b |
North Carolina | 6 | c |
ArcGIS online seems to only allow me to show information for one row at a time within the symbology (i.e. I can sort the symbology by max Number of Household Members and get a 6 for the symbology, or sort by min Family ID to show a 3 for symbology). However, I want to aggregate the sum for Number of Household Members and show that in the symbology (i.e. a 10 for the state of North Carolina).
Is there any way to do this that I am missing?
I have thought to add a column in my data preparation step to sum up each value and include that as a static repeating row in the data (i.e. have a column called Static Total Number of Household Members), but that limits me in my ability to filter the map using other data columns, like if I wanted to only view the data for household a, the symbology would still show a 10, so that is not a complete/viable solution.
Thanks!