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
How to retrive total duration based on a value state? Fluxlang influxdb	0	300	April 4, 2023
Influx Database with duration and time - convert to time series InfluxDB 1 influxdb	2	1223	September 26, 2022
Calculate operating hours InfluxDB 2 influxdb , grafana , query	2	980	February 9, 2023
Sum up of stateduration Fluxlang	3	739	April 20, 2020
Get duration of certain field value InfluxDB	1	477	September 26, 2022