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
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives