Hello, a search is retrieving following results order by event date
Date value
2023-03-02 22PM 10
2023-03-02 20PM 05
2023-03-02 17PM 25
2023-03-02 06AM 03
Considering value, I'd like to calculate the % betwen those two (PrevLatest*Latest)/100
(5*10)/100=0.5 "50% "
I'm new on this, any idea on how to achieve it?..this has to be used to raise an alert
many many thanks
| streamstats latest(value) as previousValues window=2 current=f
| eval percentageChange=100*value/previousValue