Hi,
I would like to use transaction to calculate the difference between multiple fields.
with this...
index="test" | transaction ID startswith="start" endswith="end" | table ID Timestamp Value1 trigger duration
i get..
ID Timestamp Value1 trigger duration
123 04.11.14 15:00 44 start 60.00
04.11.14 15:01 30 end
what i need is the difference of Value1 and the duration like this...
ID Timestamp Value1 trigger duration
123 04.11.14 15:00 14 60.00
Does anyone know how to subtract two Values in a Transaction?
... View more