How to change count to percentage in stack bar chart?

Hi SS Community,

I have attached two stacked bar charts I created for showing status of part shipments between sites. An example of the formula I used in my supporting sheet is: =COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA")

If it is a formula issue, what do I need to add/change about the formula so that the data shows as percentages and not counts?

Thank you!

-Brad

Find more posts tagged with

Formulas

Dashboards

Accepted answers

Paul Newcome

You would need to calculate the percentages via formula which would be the count of delivered divided by the total count:

=COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA") / =COUNTIFS({X-Site Build Stage}, "POM to IHA")

All comments

Paul Newcome

You would need to calculate the percentages via formula which would be the count of delivered divided by the total count:

=COUNTIFS({X-Site Shipping Status}, "Delivered", {X-Site Build Stage}, "POM to IHA") / =COUNTIFS({X-Site Build Stage}, "POM to IHA")

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.