How to Make a graph with the differences

[#1]

Hello Guys,

The graph does not see good if I select the CounterRdgDifference

How Can I get this correct as I dont want this firstvalue to be seen.

Thanks

sravan

[#2]

I hope someone can help me.

Thanks a lot

sravan

[johnw · Accepted solution]

I believe this:

sum(aggr(if(MeasuringReading<>DifferenceReading, DifferenceReading), Calendar.Year, Calendar.Month, Calendar.Day))

However, what I'd do instead is fix the difference reading as you load the data:

if(MeasuringReading<>DifferenceReading,DifferenceReading) as DifferenceReading

Then you can just use this:

sum(DifferenceReading)