Hi all Just getting into influx dB and Grafana I have a lot of data coming from home assistant to influx dB. As an example of what I want to do My TV has a state sensor, on or off logged in influx dB How can I aggregate the state data based on timestamp into total time the device was in that stat…

Using elapsed to get the total time a state was active

grant1 February 12, 2023, 10:13pm 2

In case @Robbrad is still wondering, this is possible in Flux. See here.

Topic		Replies	Views
Trying to get an average over n days and I must be doing it wrong	4	8436	August 14, 2018
Query to work out how long a machine has been running Dashboards influxdb , grafana	0	550	April 13, 2018
How to aggregate data on duration Telegraf kapacitor	2	656	October 30, 2018
Time since last series data time	2	3557	December 5, 2019
No Timestamp if i summary Data InfluxDB 2	5	456	December 14, 2022