Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Starting from the bellow table(Delta is the desired output) I would like to get the delta between rows and from that data to make a graph.
Initially, every minute I had a value, but I used AGGR to get the hourly average( AGGR(AVG(values),ora).
What is the best way get the delta between the rows in order to display it in a graph ?
Thank you,
Costi
@CostinelRO you an try below in expression. Make sure that your dimension is sorted by hour otherwise above function won't work as expected
=value-above(Value)
@CostinelRO you an try below in expression. Make sure that your dimension is sorted by hour otherwise above function won't work as expected
=value-above(Value)
Thank you @Kushal_Chawda .