Visualization issue - Line Chart

[aviadbein]

Hi all,

Attached screenshot of a line chart of dimension with two values (2 lines - blue and red) and for some reason I get third gray line that does not appear in my database.

i tried to get rid of it but so far without success. any suggests?

Thanks in advance

[OmarBenSalem]

Can you please share your app, to directly take a look at your chart?

[satheshreddy]

Hi Aviad,

Please change the color for third Line.

regards

Sathish

[Patrik_Lundblad]

Hi Aviad,

You have null values in your data, time periods with data but no caNickName. Go into the second dimension and uncheck "Include null values"

Regards,

Patrik.

[aviadbein]

Hi Sathish,

But there is no data of third line. Actually, it's a ghost line. Maybe it's a result of null values, but if it's the reason why I don't have "Include null values" check box on the dimension?

[aviadbein]

Hi Patrik,

It's exactly what I thought but for some reason I don't have this checkbox:

[shraddha_g]

are you using any extension for this

[Patrik_Lundblad]

Hi Aviad,

I also just realized it. The check box for null value on the second dimension is gone when using a continuous axis. I expect it to be gone on the first dimension, but not on the second. I'm about to file a bug on it.

But in the meantime you would have to modify your expression/dimensions so that no null values are included. Like replacing null with 0.

Sorry about this.

Regards,

Patrik.

[satheshreddy]

Hi Aviad,

Please Share your sample file, its better to find easily solution.

Regards

Sathish

[aviadbein]

Thanks!