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
Solved! Go to Solution.
Actually, I just found a workaround.
Switch off continuous mode on the X-axis property in presentation. Go to data section and uncheck the null value option. Then turn continuous mode back on and the line should be gone.
Definitively a visual bug where the option should not be removed.
You have null values in your data, time periods with data but no caNickName. Go into the second dimension and uncheck "Include null values"
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?
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.