I want to calculate the working time of a component. The speed signal is available in an InfluxDB. So I need a query that calculates the sum of time span in which the speed is not zero. With this I filter the data. But I don’t know how to get the timespan. from(bucket: "${bucket}") |> range(star…

Hello @Nick135 , Have you tried using the stateduration function? stateDuration() function | Flux 0.x Documentation stateDuration() returns the cumulative duration of a given state.

Hello @Anaisdg , this function sound exactly what I need, but I get the wrong result. from(bucket: "${bucket}") |> range(start:2022-12-29T09:00:00Z, stop:2023-01-23T12:30:00Z) |> filter(fn: (r) => r._measurement == "${measurement}" and r._field == "Speed" ) |> stateDuration(fn: (r) …

@grant1 The result is better but not good. If I sum “_value” == 0 and “_value” > 0 the result is 599.5h => 24,98 days not 26,14 days. from(bucket: "${bucket}") |> range(start:2022-12-29T09:00:00Z, stop:2023-01-23T12:30:00Z) |> filter(fn: (r) => r._measurement == "${measurement}" and …

Does anyone else have an idea how to solve this problem? Is the problem possibly the precision of the float data type?

Flux: Calculate for how long was a field value not zero

InfluxDB 2

grant1 March 7, 2023, 9:16pm 4

@Nick135

Have you seen this thread or this thread? Both are similar to what you are wanting to do.

Topic		Replies	Views
Calculate duration when measurements are non-zero InfluxDB 2 influxdb , time-series , flux	4	1099	August 7, 2022
Count (in seconds) how long a value is '1' Fluxlang	12	2908	April 21, 2025
Get duration of certain field value InfluxDB	1	502	September 26, 2022
Summarize stateduration to have total "on" hours per day InfluxDB 2 influxdb , time-series , influxql , query	9	1203	March 27, 2025
Calculate stateDuration based on conditional logic of another column influxdb , flux	11	318	April 24, 2024

Flux: Calculate for how long was a field value not zero

Related topics