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	469	April 20, 2022
Count and calculate the duration of Boolean true influxdb , kapacitor , chronograf , influxql , tickscript	0	674	April 20, 2022
Calculating duration of boolean events using Flux Fluxlang	5	744	January 16, 2023
Get duration of certain field value InfluxDB	1	480	September 26, 2022
Event duration calculation InfluxDB 2 influxdb	4	68	January 26, 2025