baseline,The previous value minus the next value？

[laiyongmao]

hi,all
I want to make a baseline，statistical the success rate.The current time success rate minus the last time success rate, then, divided by the time 60m,all the success rate of such,what should I do?

thanks

[somesoni2]

Try something like this

Your base search giving fields 'Time' and 'rate' | sort Time | streamstats current=f window=1 first(rate) as prevRate | sort -Time | eval baselineRate=round((rate-prevRate)/60,2)