How to make a graph showing the tally of numbers depending on the dropdown selected?
Hello all,
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.
TIA!
Best Answer
-
Hi Meghan,
I believe I understood what you are asking for. How I would approach this scenario is to create a report of your sheet and include the Audit Name and Number Completed columns.
I made a very quick sample report only using 3 types of Audit Names to show you how to set it up:
You will want to group the report by Audit Name and summarize the report by Number Completed and sum.
You can then use this report to generate the graph in your dashboard, as displayed below.
Hopefully this helps. :)
Answers
-
Hi Meghan,
I believe I understood what you are asking for. How I would approach this scenario is to create a report of your sheet and include the Audit Name and Number Completed columns.
I made a very quick sample report only using 3 types of Audit Names to show you how to set it up:
You will want to group the report by Audit Name and summarize the report by Number Completed and sum.
You can then use this report to generate the graph in your dashboard, as displayed below.
Hopefully this helps. :)
-
YES! this worked perfectly. I had a report built but didn't realize the "sum" needed to be put instead of "count" :) Thank you SO much!!
-
@meghan.berger Happy to help. :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!