@SimonTurton - You can use streamstats command for that. Your query here
| streamstats current=f window=1 values(Server*) as Prev_Server*
| foreach "Server*" [| eval "Change <<FIELD>>"=round((<<FIELD>>-Prev_<<FIELD>>)*100/Prev_<<FIELD>>,2)] Here is my sample query that I used to test: | makeresults | eval Server1=66.0454, Server2=62.2212
| append [| makeresults | eval Server1=68.8615, Server2=63.6594]
| append [| makeresults | eval Server1=68.0096, Server2=57.1727]
| streamstats current=f window=1 values(Server*) as Prev_Server*
| foreach "Server*" [| eval "Change <<FIELD>>"=round((<<FIELD>>-Prev_<<FIELD>>)*100/Prev_<<FIELD>>,2)] I hope this helps!!! Upvote/karma would be appreciated!!!
... View more