I have a bar chart that has statewide data as well as counties (see image below). Following are the fields that I used for this image. The New York County field does not have Statewide.
I was wondering what is the best way to set this up?
|Date Field||Has the field to calculate the years|
Have 2019, 2020, 2021, and 2022 data
|1/1/2019, 1/2/2019, 1/3/2019|
|New York County||Has the counties for New York|
Does not have Statewide
|Central, Hudson Valley, Long Island|
|Count Field||This field has a value for all rows in the report so that all rows are counted|| |