How do I change the "Not Available" displayed when I Icon in the Dashboard status updates?
When creating a dashboard I have selected to have a Chart Widget to display a summary of information on the Dashboard. When there is no information in the Open status in the Sheets where the data is being pulled from. the current display in the Chart Widget reads "The source data for this chart has been changed. This chart type must have one set of labels and one set of values." The display is a caution triangle.
How do I resolve this so that when there are no open items in this area instead of this results; I can get a zero displayed instead of the erroneous message".
Best Answer
-
Hello @Stan Kinney ,
You may instead wish to create a Metric Sheet that contains E.G counts of each status type. Please see my example below:
Source Sheet:
Metric Sheet:
These cells contain the following Formula: =COUNTIF({Automation test Range 1}, HAS(@cell, [Primary Column]@row))
Dashboard Chart View:
This way the Metric Sheet will allow for ease of use with Charts by collecting values from the Sheet, and if none are present, it populates with 0 so the Chart remains empty until populated in the Source Sheet, and then fed into Metric Sheet
Let me know if you have any questions!
Regards
Sean
Answers
-
Hello @Stan Kinney ,
You may instead wish to create a Metric Sheet that contains E.G counts of each status type. Please see my example below:
Source Sheet:
Metric Sheet:
These cells contain the following Formula: =COUNTIF({Automation test Range 1}, HAS(@cell, [Primary Column]@row))
Dashboard Chart View:
This way the Metric Sheet will allow for ease of use with Charts by collecting values from the Sheet, and if none are present, it populates with 0 so the Chart remains empty until populated in the Source Sheet, and then fed into Metric Sheet
Let me know if you have any questions!
Regards
Sean
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 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
Check out the Formula Handbook template!