How can I display values of zero or null values in a chart or graph?
For example, tracking activities or meetings set, I want my graphics to display dates /date ranges with results of zero. Currently my graphics just skip those dates/date ranges which shows inaccurate trends.
Any ideas?
Hello @Skyler Hoffner,
As I know, there is a solution to display zero or null values in your charts.
First, you need to be sure your queries include all dates and handle null values properly. Then you need to create a complete date range in your data source and replace nulls with zeros. Enable options in your chart settings to display zero values or data labels. Also, take a look at chart types, because line charts or bar charts can better show zero values. Then adjust custom chart code or visualization library settings to include zero values.
This approach should help
