Create a chart using single-select dropdown
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
Answers
-
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.
-
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!
-
You would need to group by the Type.
-
Hi Paul, we have grouped by type and the result is the same.
-
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!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives