Hello,
I have a condition when the variable new_tag of the previous row is equal to 1 and the variable test_tag of the current row is equal to 1 I must subtract the start value of the previous row with the start value of the current row.
I want the result of the subtraction to be written in the previous row in the result column.
Unfortunately I could only get this subtraction to be written to the current row in the result column.
Please could someone help me, thank you very much.
| reverse
| streamstats window=2 first(result) as result
| reverse
Thank you very much!