Chart creation - Omitting Null values

Highlighted
Contributor

Chart creation - Omitting Null values

Hi Team,

 

   i would like to create a chart wherein the zero values need not be plotted on a graph.In other words, I would like to create a chart excluding the null / zero values,. Please provide some guidance on the same. Existing chart screenshot is attached herewith for your ready reference. 

 

Thanks and regards,

Aishwarya

Message 1 of 13
12 REPLIES 12
Super Contributor

Re: Chart creation - Omitting Null values

Hi Aishwarya,

 

You can create a filter that only shows list members with values, then create a Saved View.

You can then create a graph out of this Saved View, and the graph should reflect accordingly, i.e. show list members with values in the graph.

Please note that this method only works with custom list, and not with Standard Time.

 

Thanks,

LipChean

Message 2 of 13
Contributor

Re: Chart creation - Omitting Null values

Thank you for the solution, we shall try it out and provide feedback!

Message 3 of 13
Contributor

Re: Chart creation - Omitting Null values

Hi LipChean,

 

      I have tried your solution . Filtering the zero values is also resulting in hiding of the concerned timeperiods on the x axis. I would like to know if there is a solution wherein the x axis would display all the time periods irrespective of the quantities against them; only the chart plot needs to be blank for zero values. 

 

Thanks and regards,

Aishwarya

Message 4 of 13
Expert

Re: Chart creation - Omitting Null values

I wonder how not-a-number (NaN) is treated by the chart. If it omits them then you just need map zero to NaN. You can create a NaN using DIVIDE with zero as the second argument.
Message 5 of 13
Contributor

Re: Chart creation - Omitting Null values

Thank you , I shall check the same the revert to you if it works

Message 6 of 13
Contributor

Re: Chart creation - Omitting Null values

Hi @ben_speight ,

 

        We have tried using NaN logic, but we are still not getting the desired result. The supporting screenshots are attached herewith. 

 

Thanks and regards,

Aishwarya



 

Super Contributor

Re: Chart creation - Omitting Null values

Hi Aishwarya,

 

What does 'only the chart plot needs to be blank for zero values' mean?

 

Thanks,

LipChean

Message 8 of 13
Contributor

Re: Chart creation - Omitting Null values

Hi LipChean,

 

       I mean the chartline should be truncated at points where values are zero ( though their corresponding time periods would still remain plotted on x axis). When we filter the values, the corresponding time periods also get hidden. We would still want such time periods also to be displayed on the x axis.

 

Thanks and regards,

Aishwarya

 

Message 9 of 13
Super Contributor

Re: Chart creation - Omitting Null values

Hi Aishwarya,

 

Do you mean for points where the value = 0, you still want to show the time, but not the value = 0?

For example, assuming we have Jan = 1, Feb = 0, Mar = 5; you want to show a graph where Jan, Feb and Mar are still on the x axis; and the line connects from value = 1 to value = 5, instead of 1 to 0 to 5?

 

Thanks,

LipChean

Message 10 of 13