Calculating % of a category for Circle Graph (Dashboard)
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!
Best Answers
-
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.
-
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})
Answers
-
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.
-
It's just that easy, huh? I'm ALWAYS trying to overcomplicate things. :)
Thanks for the help!
-
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})
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!