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?
Thank you.
| Field Name | Description | Example |
| 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 | |
