How to make a graph showing the tally of numbers depending on the dropdown selected?

meghan.berger

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!

juliesilverio

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. :)

juliesilverio

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. :)

meghan.berger

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!!

juliesilverio

@meghan.berger Happy to help. :)