Is n’t it zero?
I think the second transaction doesn't return a value because there is no keyword in _raw.
Is it all right to be grouped like this in the first place? stageTime1 is multi-field.
KEY,stageTime1
A1,10
A2,20
A3,10
B1,10
B2,20
B3,30
KEY,stageTime1,stageTime2
A,10,100
20
10
B,10,500
20
30
If there is no parent-child relationship between two transactions, how about calculating and merging them separately?
(your search transaction1)| rename duration as stageTime1
|timechart span=1h avg(stageTime1) as stageTime1
|append [search (your search transaction2)| rename duration as stageTime2
|timechart span=1h avg(stageTime2) as stageTime2]
|stats latest(*) as * by _time
... View more