I have a lot of dropdowns for each region in my service area. I need to be able to quickly tell which regions do not have any items on the board. I made a chart with the number count of items as Y and regions label as X but it only shows regions which DO have items. The “show empty values” option is not what I am looking for- this only shows a number count of how many items don’t have a region listed.
E.g., I want a chart that shows:
- Charlotte- 0
- Myrtle Beach- 0
- Raleigh- 1
- Greenville- 2
- Wilmington- 3
But currently the 0’s aren’t showing up.