i have a power switch for my boiler which i’m using for some time now. i’m displaying its usage in the past day and week using history graph.
i wonder - is there a way to pull out a report of the usage in the last year for example or for a period of time - for example - show me the total number of hours that the boiler was one in the last 3 months.
If you already have collected the necessary data for some time, maybe you can run a simple sql query against your MySQL database?
Btw: Grafana can also use MySQL as a possible datasource and doesn’t need any time series databases like influx anymore.
Allthough querys against timeseries databases in Grafana still much easier.
just ordered the pi3 b+
that was a good incentive - used pi1 to do the POC for home assistant and see if it fits my needs. time to move to a real board.