Hi All,
I want to make a bar chart showing daily electricity consumption. The value pulled in from the data source is an accumulating value of the total electricity usage for the building.
I then use
Max( {<SensorMeasure = {'Electricity'}>} Aggr(Max(Value), EntryTime)) - Above( Max( {<SensorMeasure = {'Electricity'}>} Aggr(Max(Value), EntryTime)) )
to calculate the daily increments. (See image 1).
Then I plot the daily usage on a bar char (See image 2)
But when I make selections on the bar chart, it only shows the day after the first selected date (due to the chart looking for an 'above' value) (See image 3)
Does anyone know if there is a work-around for this? or if there is an alternative way of displaying the same results without using above()?
Thanks
