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

Answers

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭

    @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.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    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.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!