Null behavior as zero not working on line chart

Sam shared this question 8 days ago
Awaiting Reply

I'm trying to take advantage of the null as zero option, but it's not working for me. This red segment is the problem:

/8ff971d5cba94e5cb120568a18ed7991

Here is the underlying data, filtering only for records in that red series:

/fb7055b33c946e63c13578a5242c5205

And indeed the chart has the right data points, y = 2 for the interval 2018-07-10 to 2018-07-12 and then y = 6 for the date 2019-04-02, which is not grouped together with other dates. But it should not be drawing a line between them.

I have all three fields used in the chart set to Null Behavior = Zero, like this:

/cd3611afca3cba05c0bff6be3197636d

Can you advise on what else I might try to get rid of this connected line, which should be zero for the many dates between its 2 and 6 values?

Comments (1)

photo
1

Hi Sam,


Apologies for the delay.


We have an option in the chart settings to Fill the gaps for each granularity period based on the Null Behavior selected(zero in our case). Please refer to the attached screenshot.

Kindly let me know if that helps.


Best Regards,

Deepak