Null Behavior Option not visible in Line chart settings

Pravin Pandey shared this question 2 months ago
Answered

Hi Team,

I have been trying to hide the Zero/ Null values(Plots) in a line chart , for which i have referred the incident "How to avoid line chart to show drop due to null values of future?", but as mentioned in the incident, the null behavior option is not visible in the Chart settings , please check the below screenshot.

Kindly suggest.

/c4c2935d32cd791d2f54fa83f7c2b018


Thanks & Regards,

Pravin Pandey

Comments (3)

photo
1

Hi Pravin,

Thanks for reaching out. You're only going to get the Null Behavior option if you have actual Null values in your report. I took a look at the ticket you linked and based on what I read there, it's not indicated there's actual null values, just that the data set for one of the lines ends:

/288379ac7b5dc6df39d9de92fb6454a9

If whichever dimension that corresponds with the purple line doesn't have a null value at 8, and it's a 0, then there's just no data for the rest of the Hour's, there will be no Null Behavior option in the Chart Settings.

As such, do you have any null values in your reports data set? If not, I hope this explanation makes sense and please let me know if you have any further questions.

Regards,

Mike

photo
1

Hi Pravin,

I just wanted to check in and see how things are going with this.

Regards,

Mike

photo
1

Hi Pravin,

I'm going to go ahead and mark this one as Answered since I haven't heard back from you, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike