Dashboard chart from sheet
Hi all,
I am trying to create a dashboard chart widget on my RAG status. I have used the symbols in the sheets (Red, Amber, Green, Blue.
However, when selecting this data via the widget, I get the following message "the selected columns cannot be charted...."
Any advice if I can do this or it just isn't with the functionality?
Thanks in advance!
Best Answer
-
RSP,
We are using the sheet symbols as well in one of our status reports. We are counting the status icons in that sheet in a set of columns using =countif(column:column, =Color#) as each status icon has a specific number to it. You can then create a chart based off that data. However, if you do not want that set of columns to be on the source sheet I would suggest creating an intermediate sheet for just generating the chart data and use "reference another sheet". Also, you can count in the sheet summary, but you cannot chart from it, you could use a metric widget to display the values.
Answers
-
RSP,
We are using the sheet symbols as well in one of our status reports. We are counting the status icons in that sheet in a set of columns using =countif(column:column, =Color#) as each status icon has a specific number to it. You can then create a chart based off that data. However, if you do not want that set of columns to be on the source sheet I would suggest creating an intermediate sheet for just generating the chart data and use "reference another sheet". Also, you can count in the sheet summary, but you cannot chart from it, you could use a metric widget to display the values.
-
Thanks Mark,
I have created the intermediate sheet and that works well. I shall use this going forward.
-
@RSP I have the exact same issue (thanks for sharing that screen shot). Could you please share how you built the intermediate sheet?
Thanks
Scott
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives