Stacked Bar Chart Data Sheet

Hello

I am trying to create a stacked bar chart based on the following:

I have a multi-select dropdown column, so there may be more than one value in it.

I then have a second column with Priority listed.

I have created a sheet that calculates how many times each drop down is used but I want to know how each drop down relates to the priorities.

I'm looking for a chart to show me that, for example, 'user experience' makes up 5 x high priority items and 6 medium items etc.

There are more in the Risk or Issue Type than Priority which is why I want to incorporate the two on the same chart.

Can someone please help me with the formula?

Thanks in advance

Find more posts tagged with

Formulas

Accepted answers

All comments

Leibel S

@KatieDi

Using COUNTIFS you can keep on adding ranges and criteria.

=COUNTIFS({Risk or Issue Type Column}, HAS(@cell, [Risk or Issue Type]@row), {Priority Column}, @cell = "Critical")

Replace bolded parts of formula as needed...

KatieDi

This is great, thank you.

If I wanted to add in another criteria whereby it looks at another column and only counts if a certain criteria is met, e.g. Column name is 'Form Type', and I'm looking to bring in where the form type = contact form.

I'm sorry, I'm just not very competent at formulas.

Thank you

Katie

Leibel S

@KatieDi

Yes, you can keep on adding as much as you need:

=COUNTIFS({Risk or Issue Type Column}, HAS(@cell, [Risk or Issue Type]@row), {Priority Column}, @cell = "Critical", {Form Type}, @cell="contact form")

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.