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	289	April 4, 2023
Influx Database with duration and time - convert to time series InfluxDB 1 influxdb	2	1191	September 26, 2022
Get duration of certain field value InfluxDB	1	473	September 26, 2022
Calculate value range of a field/column InfluxDB 2 flux	2	580	January 22, 2021
Fluxlang query tu sum when value is high Fluxlang	3	462	March 23, 2022