History data collected analyze

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.

Search for Grafana.

can you elaborate a bit please? how is grafana related to it? should it be connected to the mysql data file?

Grafana uses influxDB to store long term data. There are many tutorials on YouTube on how to set it up. There is an addon for Hassio.

oh i see - so you mean not to use the mysql db of HASS and instead or in addition write the outputs to another db - am i getting it right?

No it is a seperate DB for long term data.

i can see both grafana & influxDB addons in Hass.IO, but for both it says “not available on your system”. i’m using raspberry - is this not supported?

Maybe this sensor may help?

Limitations: https://github.com/hassio-addons/addon-grafana#known-issues-and-limitations

thx - using pi 1 is the reason.

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+ :slight_smile:
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.