How to Calculate the difference between two rows of a column?

[Splunk_321]

I have a splunk query shown below.

basesearch
| stats avg(time) as executionTime by method

which results in table like below

method               executionTime
A                        110.350
B                         90.150

I want to obtain executionTime difference between method A and B in a table result

A-B = 20.20

Please help me with splunk query to get the same.

Thanks in advance!

[gcusello]

Hi @Splunk_321,

you have to put them in the same row, something like this:

basesearch
| stats 
   avg(eval(if(method="A"),time,0)) as executionTime_A
   avg(eval(if(method="B"),time,0)) as executionTime_B
| eval diff=executionTime_B-executionTime_A

Ciao.

Giuseppe