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
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!