How to deal with spare tables

Question

Hi all, I am representing a spare table using the CHART ENGINE DESIGNER (using the line chart). Unfortunately it seems to have some problems when trying to plot NULL values. I can manage to change the query and exclude the rows with some NULL values, but I am losing a lot of data: any hint?

Answer 1

Dear Angelo

can you describe the problem plotting null ? Can you find any errors inside log files or Browser console ?

Let me know

Angelo.

Comments

Ciao Angelo,

unfortunately all the logs do not contain any relevant error, while the browser console is just printing a very general error:
SyntaxError: Unexpected token ,
    at chartRenderer.js:84
    at angular.min.js:122
    at m.$eval (angular.min.js:137)
    at m.$digest (angular.min.js:134)
    at m.$apply (angular.min.js:137)
    at g (angular.min.js:91)
    at t (angular.min.js:95)
    at XMLHttpRequest.w.onload (angular.min.js:96)


Steps to reproduce (only the main ones):
- create a new dashboard
- add a new chart widget
- select line chart
- set attribute and measure
- save and try to visualise .. but the chart remains blank

Here the preview of my dataset: http://imgur.com/a/ztRPM