Details
-
Bug
-
Status: Resolved (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
Security Level: Public (Public issues)
-
None
-
All browsers
Description
https://www.joomlart.com/forums/topic/plot-null-values/
Trying to use JA Google Charts Module with data coming from Google Sheets, which has empty/blank/null cells in the table. This results in two undesired results.
1 – using JA Google Chart V1.02 – Line graph will consider null values as zero.
2 – using JA Google Chart 2 V 1.0 – Line graph will appear as dots (not connected)
If generating the Line Graph in Google Sheets, there’s a feature called "Plot null values" and that takes care of the issue. Please advise if I missed something in the configuration of the module, or if there will be an update incorporating such feature.
Trying to use JA Google Charts Module with data coming from Google Sheets, which has empty/blank/null cells in the table. This results in two undesired results.
1 – using JA Google Chart V1.02 – Line graph will consider null values as zero.
2 – using JA Google Chart 2 V 1.0 – Line graph will appear as dots (not connected)
If generating the Line Graph in Google Sheets, there’s a feature called "Plot null values" and that takes care of the issue. Please advise if I missed something in the configuration of the module, or if there will be an update incorporating such feature.