I trying to get total duration of value.
I have table where possible values for each record is integer 1 or 2. Value 1 means the machine is running and value 2 means the machine is stopped.
Can you please help me how to get total duration where the value is equal 1 (machine is running) ?
Thanks a lot.
this dont work for me
from(bucket: "MotoTest2") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r._measurement == "M1") |> stateDuration(fn: (r) => r.state == 2) |> yield(name: "state_duration")