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!

Find more posts tagged with

Formulas

Accepted answers

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})

All comments

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})

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.