Calculating % of a category for Circle Graph (Dashboard)

MegJF

Hi,

I need to create a circle graph or pie chart that shows my team the percentage of initiatives under each line of business. I'm using a metrics sheet to pull my data from, so the information could need to come from another (single) sheet.

Basically, I want the graph to show x% is business code ABC, x% is XYZ out of all the initiatives listed on the sheet.

Thanks!

Paul Newcome

If you are already pulling the counts onto a metrics sheet, you should be able to reference the metrics sheet directly and then adjust the settings in the chart widget to show the percentage.

Paul Newcome

No worries. I do the same thing. Haha. And to provide a little more detail... If you wanted to show the percentage on the sheet or as a metrics widget, it is actual divided by total.

=COUNTIFS({Business Code}, @cell = "XYZ") / COUNT({Business Code})

Paul Newcome

If you are already pulling the counts onto a metrics sheet, you should be able to reference the metrics sheet directly and then adjust the settings in the chart widget to show the percentage.

MegJF

It's just that easy, huh? I'm ALWAYS trying to overcomplicate things. :)

Thanks for the help!

Paul Newcome

No worries. I do the same thing. Haha. And to provide a little more detail... If you wanted to show the percentage on the sheet or as a metrics widget, it is actual divided by total.

=COUNTIFS({Business Code}, @cell = "XYZ") / COUNT({Business Code})