Dashboard bar charts showing blanks or ceros
Hi, hope you can help me. I am building a dashboard with some charts to show counts. I created another sheet where i am creating my formulas and tables that are the ones to create my chart in the Dashboard. As you can see my formulas are working fine and are showing counting just if the number is equal or higher than 0 if not leave the cell in blank, this to avoid many ceros in the chart. The problem is that still my chart is showing data in blank. Is there a way to have a more dynamic chart where will just going to show the bars that higher than cero?
Best Answer
-
To make it dynamic, you would need to create a report that references the metrics sheet and then set up the report filter to exclude (for example) rows where the total is zero or blank.
Answers
-
@Raul Cabrera In the Chart Widget under Columns Included instead of default All Columns you can select the columns you want to be display. Hopefully that should address your first chart with the blank column issue (or you can just not select the Blank column when selecting the range for the Chart Data). Try similarly for the other Chart too (it may not work as the Past Due is row and not a column)
-
HI Sammer, i think this is not the solution that i am looking due i want something dynamic that avoid manual intervention. if i adjust not to select the blank column and somebody made a change in the backend sheet and now we have at least 1 items, this will not appear in the chart until i expand in the table manually. What i need is more to have selected the same table and in some way discriminate the blanks in the chart.
-
To make it dynamic, you would need to create a report that references the metrics sheet and then set up the report filter to exclude (for example) rows where the total is zero or blank.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!