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…

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

grant1 March 7, 2023, 9:16pm 4

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

Topic		Replies	Views
Influx Database with duration and time - convert to time series InfluxDB 1 influxdb	2	885	September 26, 2022
Calculate operating hours InfluxDB 2 influxdb , grafana , query	2	718	February 9, 2023
Sum up of stateduration Fluxlang	3	640	April 20, 2020
Get duration of certain field value InfluxDB	1	392	September 26, 2022
Summarize stateduration to have total "on" hours per day InfluxDB 2 influxdb , time-series , influxql , query	8	684	March 27, 2023