I have data in an influxdb database from a door sensor. This is a boolean sensor (either the door is open (value is false) or it is closed (value is true)), and the table looks like: name: door -------------- time value 1506026143659488953 true 1506026183699139512 false 1506026751433484237 true …

Calculating event duration from boolean values?

grant1 February 12, 2023, 10:11pm 3

Just in case someone was asleep since Sep 2017, we have a solution in Feb 2023 using Flux. See here.

Topic		Replies	Views
Count and calculate the duration of Boolean true InfluxQL influxdb , kapacitor , influxql , query , tickscript	0	432	April 20, 2022
Count and calculate the duration of Boolean true influxdb , kapacitor , chronograf , influxql , tickscript	0	591	April 20, 2022
Get duration of certain field value InfluxDB	1	393	September 26, 2022
Influx Database with duration and time - convert to time series InfluxDB 1 influxdb	2	889	September 26, 2022
Continuous query with elapsed transformation influxdb	0	595	October 2, 2018