Line chart - presenting nulls as zeros

0

Hi,
I haven't encountered this issue before, but I can give you some ideas that might be useful. Use the COALESCE function to replace null values with NULL instead of zero, or add a condition in the query to not return rows with null values.

Thanks,
Raluca

Hi
While I haven't faced this issue myself, using the COALESCE function to replace nulls or adding https://nullsbrawl.gg a condition to exclude rows with null values in your query could be effective solutions.

To address the issue of null values being seen as 0, try setting up verification of data prior to chart rendering. https://nullsbrawl.gg Filter out null values in your data processing logic so that they do not show as 0. In addition, change the chart elements to omit null values and only show data points where valid values exist.