Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello. I need help displaying line chart that connects to zero values.
The data:
date, person, room
2000-01-01, A, ROOM1
2000-01-01, A, ROOM2
2000-01-01, B, ROOM2
2000-01-03, A, ROOM1
2000-01-03, B, ROOM2
2000-01-03, C, ROOM2
The data is missing a date (2000-01-02), so I use Master Calendar to generate the missing dates.
Line chart I want
I expected that it would show 2000-01-02 as 0 like this figure:
but as soon as I added Line dimension (room), it no longer connected to that point.
Is there any way I can use Line dimension and have the lines connect to the point at 0 at that date?
Thank you.
Thanks for the reply. I tried every 'Missing Values' options (show as gap, show as connection, show as zeroes) but the chart's appearance remained the same. I've confirmed that the x-axis is in Continuous mode.