Is it possible to have a line chart with null values that don't appear? I attached a chart (chart.png) created with wpDataTables, as you can see, the blue line is 0 from 01/05/2017 till the end. Those values in the database are NULL, so I would like to hide them so the blue line should end at 01/04/2017 to get something like chart2.png
I see that when you find a null value for a int,float,double column, you put a 0. Which php file should I edit to overwrite this behaviour and to put a null instead of a 0?
Unfortunately something like this is not possible with the plugin build in. But if you want to change the code you can find all that logic for charts in file ../wp-content/plugins/wpdatatables/source/class.wpdatachart.php but please be aware when the update is released you will need to overwrite the code again.
Hi.
Is it possible to have a line chart with null values that don't appear? I attached a chart (chart.png) created with wpDataTables, as you can see, the blue line is 0 from 01/05/2017 till the end. Those values in the database are NULL, so I would like to hide them so the blue line should end at 01/04/2017 to get something like chart2.png
How can I do that?
In other words...
I see that when you find a null value for a int,float,double column, you put a 0. Which php file should I edit to overwrite this behaviour and to put a null instead of a 0?
Hi Effenmark,
Thank you for your purchase.
Unfortunately something like this is not possible with the plugin build in.
But if you want to change the code you can find all that logic for charts in file ../wp-content/plugins/wpdatatables/source/class.wpdatachart.php
but please be aware when the update is released you will need to overwrite the code again.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi guys.
I've got the same problem, did you solve it maybe?
I need this also, for example in Grafana there is such option for null values.
Graphs looks stupid when sometimes, i've got null values.
HI phantasm83
I can see that my college is replied to your ticket so he will help you out for this case.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables