Create a chart using single-select dropdown

hcastro

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

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

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

You would need to group by the Type.

hcastro

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

Kelly P.

@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