Chart creation - Omitting Null values

Contributor

Re: Chart creation - Omitting Null values

Hi LipChean, 

 

    Yes , that is exactly what I meant. 

 

Thanks and regards,

Aishwarya

Message 11 of 13
Super Contributor

Re: Chart creation - Omitting Null values

Hi Aishwarya,

 

To create a NaN, you need to write Divide(0,0).

Inserting NaN in the module, the following graph is derived.

 

Screen Shot 2019-03-21 at 8.22.02 AM.png

I prefer having 0 in my graph, because it's reflecting the true value.

 

But if you're still looking for a graph that bypasses 0, and connects only values, i think there's 2 choices:

1. Create a module that filters out zero, create a line chart out of the non zero values. Then at the bottom of the line chart, create a module with all values (including the zero), and use conditional formatting to highlight these zeroes, so that users can still tell when the zeroes happen.

 

2. The other option is to mathematically derive a value to replace the zero, so that we don't get what we see above in the NaN graph, eg if Jan = 1, Feb = 0, Mar = 5; then derive 3 for Feb so that there's a smooth line connecting Jan to Mar. However this approach has 2 problems, i.e. first of all, it sends the wrong message because i'm seeing Feb = 3 in the graph, but the module is saying 0. Secondly it's not easy to derive these values, especially when there could be more than 1 zero between values, eg Jan = 1, Feb = 0, Mar = 0, Apr = 0, May = 5.

 

Thanks,

LipChean

Message 12 of 13
Contributor

Re: Chart creation - Omitting Null values

Hi LipChean,

 

    Thanks a lot ! NaN creation using Divide function works for us. Our zeroes and either at start or at the end , hence this solves our purpose. 

 

Thanks and regards,

Aishwarya 

Message 13 of 13