Create a chart using single-select dropdown

hcastro · 02/22/23

As we're building a dashboard with corresponding RAID items, we are breaking up the "Type" column into "Risk" "Action" and "Issue." However, when we attempt to create a chart out of the corresponding report, it captures only the total "Type" for the entire column instead of breaking out each Risk, Action, and Issue into three separate legend items

Victoria_Indimar · 02/22/23

Can you provide a sample of what your sheet/table looks like that you're building the chart off of?

I think it's just the chart settings you'd have to adjust but depends on how your table is setup and what's selected to chart.

hcastro · 02/22/23

Hi Victoria,

I attached both screenshots, please let me know if this is enough information. We've tried working with the setting and both in the Legend and Columns included we can't break up the detail. Thanks!

Paul Newcome · 02/22/23

You would need to group by the Type.

hcastro · 02/28/23

Hi Paul, we have grouped by type and the result is the same.

Kelly P. · 02/28/23

@hcastro

Perhaps it would be helpful to use a summary/metric sheet as the data source rather than a report. See screenshot 1 for how the metric sheet could look. The formulas in each column are:

Issue: =COUNTIFS({Epic}, [Primary Column]@row, {Type}, "Issue")

Action: =COUNTIFS({Epic}, [Primary Column]@row, {Type}, "Action")

Risk: =COUNTIFS({Epic}, [Primary Column]@row, {Type}, "Risk")

See screenshot 2 for how this data can be graphed.

Hope this helps!

Metrics.PNG

Graphic.PNG

Smartsheet Basics

Smartsheet Basics

Create a chart using single-select dropdown

Answers

Quick Links

Categories

Trending in Smartsheet Basics

Conversations in Sheet vs Report (for the Sheet)

Looking for Guidance on Smartsheet Aligned Solution Professional Certification

Conditional Formatting