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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives