Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 amiroh81
		
			amiroh81
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 amiroh81
		
			amiroh81
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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?
 sunny_talwar
		
			sunny_talwar
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Can you try unchecking 'Suppress Zero-Values' from the Presentation tab of the chart properties and see if that works for you.
 amiroh81
		
			amiroh81
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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.
