Charts built off of reports


I have some charts that are built off of reports pulling from multiple metric sheets counting data entered in the last 30 days, 5 days and 24 hours. The reports are set to look at and add only the items that have a number greater than 0 in the 30 days column as there is a huge list and we wanted to simplify that list to just the items that have numbers to report. The issue we are running into is that when there is no data to report, the chart breaks instead of showing 0 values. Is there a way that I am not thinking of to keep the chart from breaking, but also keep that list simplified to just the items that have a number to report? Screenshot attached of the message showing on our dashboard.

Best Answer