2. PHPRunner General questions
  3. Ignore empty or NULL values in line chart
This topic is locked

Ignore empty or NULL values in line chart

 		11/20/2018 2:09:03 PM
PHPRunner General questions
J
 jiscar author

Hi

I have values like This:
Data




My Chart: cumulative sales charts



How to handle empty or NULLvalues in a line chart
Thx
admin 11/20/2018

Maybe you need to change your SQL queries to skip NULL values i.e.

select ...

from ...

where ActuelesJahr is not null


The syntax above is for MySQL.
J
 		jiscar author 11/23/2018



Maybe you need to change your SQL queries to skip NULL values i.e.

select ...

from ...

where ActuelesJahr is not null


The syntax above is for MySQL.


thanks for your reply but I can not change my query!

I have a cumulative line chart that shows current year (AktuelesJahr) vs previous year (VorJahr) growth.

I want to display all months (MM), but for the current year (AktuelesJahr) obviously we don't have data for all months (MM).

and I don't want a line for the current year if there is no data (data=0), I want it to stop
Is possible to make le line transparent where the value is 0?
Thx