Templating a stateDuration alert task

[AdamSLevy]

The link that I couldn’t include:

Calculating event duration from boolean values?

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 1506026761473122666 false 1506043848850764808 true 1506043887602743375 false I would like to calculate how long the door was open in a given period of time. The ELAPSED function gets me close, but I…