Archive

baseline,The previous value minus the next value?

laiyongmao
Path Finder

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,alt textwhat should I do?

thanks

Tags (2)
0 Karma

somesoni2
Revered Legend

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)
0 Karma
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!