Hello, I am trying to get a query to return the correct number of minutes (or hours) using stateDuration for a metric collected every 10 minutes. Here is what I have but it returns odd results: from(bucket: “my-bucket”) |> range(start: 2023-11-02T21:45:54.088Z, stop:2023-11-09T22:45:54.088Z) |> f…

stateDuration for metric collected every 10 minutes

grant1 November 11, 2023, 11:20pm 4

Have you read through this? It sounds like you are trying to do the same thing. Not saying that stateDuration will not work, but I used elapsed in the aforementioned thread

Topic		Replies	Views
Summarize stateduration to have total "on" hours per day InfluxDB 2 influxdb , time-series , influxql , query	8	953	March 27, 2023
stateDuration, wrong output Fluxlang	4	683	January 24, 2020
Flux: Calculate for how long was a field value not zero InfluxDB 2 influxdb , query , flux	5	1234	March 20, 2023
Fluxlang query tu sum when value is high Fluxlang	3	462	March 23, 2022
Write data to bucket _time is always off by 10 seconds InfluxDB 2 influxdb , query , flux	3	391	August 11, 2023

stateDuration for metric collected every 10 minutes

Related topics