Home > Forum > General > Line chart - presenting nulls as zeros

Line chart - presenting nulls as zeros

0

LukaszJanicki

18.06.2024

16:10

LukaszJanicki

Hi,

I've inserted a line chart to my form. It gets data from database (4 columns). 2 columns are presented on a chart as data series. Sometimes there are nulls in one of the columns. Then Webcon interpreters it as 0. Do you know any countermeasures to it? If there is a null value from the database, then it shouldn't show that line at the given point in time.

I attach a photo of that such graph with nulls as zeros.

Would be grategul for your help.

20.06.2024

08:54

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

Solution (0)

Helpful (0)

Wrong answer (0)

pitterson

29.08.2024

09:03

pitterson

In reply to: Raluca-Mirabela Lupu

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.

Solution (0)

Helpful (0)

Wrong answer (0)

pitterson

31.08.2024

18:20

pitterson

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.

Solution (0)

Helpful (0)

Wrong answer (0)