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	8719	August 14, 2018
Query to work out how long a machine has been running Dashboards influxdb , grafana	0	595	April 13, 2018
Time since last series data time	2	3658	December 5, 2019
No Timestamp if i summary Data InfluxDB 2	5	537	December 14, 2022
Grouping Data per Day/Week/Month/Year Dashboards influxdb , grafana	3	924	May 16, 2024