Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a graph that shows data at hour or minute intervals.
When there are situations where there is no data at all, a line is created between the last point that is given and the next point forward and this can confuse the user (you might think that data exists at the same time).
In practice, the situation is understandable, since the values are NULL.
Is there a creative solution to overcoming this virtual line? I would prefer line 0 if possible, so the user will obviously have no data.
Thanks in advance
I think right now the data is missing which is why you see a line getting connected here... but to make it 0, you might need to generate missing data
Thanks so much for the direction.
If I understand correctly I should create all possible intervals to see line 0.
This is problematic for me because my report will be updated every time and sometimes there are different intervals.
Is there a simpler way?
Is there a possibility that the line will not connect between its two ends?
Can you try unchecking 'Suppress Zero-Values' from the Presentation tab of the chart properties and see if that works for you.
I tried but it didn't help.
By default, the QV seems to connect the dots and I couldn't find a way to cancel it.