How to make a graph showing the tally of numbers depending on the dropdown selected?
I am trying to show in a Dashboard a graph that depicts a total count of audits completed by type. So in the Audit Name Column, whenever a specific option is selected, I want the sheet to add the Number Completed with that dropdown selection for the entire sheet. So, in this chart for example: Natalie has worked on the Provider Contract with Notes audit twice. She did 63 rows on the 8th, and 4 rows on the 9th. So, I would like a way to show that the Provider Contract with Notes Audit has 67 rows completed overall.
I'd like a graph with ALL the Audit Names (shown in the dropdown) to appear on a single chart, with a bar representing the total count of rows worked (number completed).
How would I go about doing this? I am lost.
Help Article Resources
Check out the Formula Handbook template!