Possible to get historical values from energy dash board?

[maisun]

Hi:
Would like to get historical values from my water meter, basically hourly usage in past 12 hours. I have configured utility meter and in hourly state there is only value for the previous period. In energy dashboard it can show usage in past 12 hours, so I’m wondering if there is a way to get that data in automation? Many thanks in advance!

[zoogara (Daryl)]

Any way to access historical data in template?

Hi guys - I’m wondering if it’s possible to access historical sensor values from a template without setting up a new history_stats sensor. For example, pull in the value of a sensor N hours ago and compare it to current value. Thanks Dave

Also have a look at History Stats:

History Stats

And if you just want to graph it theirs History Graphs and Apexcharts.

Just depends on what you want to do with the data.

[maisun]

@zoogara

Just depends on what you want to do with the data.

Thanks my use-cases are:
I’d like to use for 2 purposes:

1. Find high water usage and avg value to predict when I need to heat/stop hot water (so statistics)
2. Detect slow water leak during sleeping period 11-06 if any water usage every hour.

Coming from OpenHAB world so the idea might be different with HA, it’s very easy in OH to query for historical data.

[zoogara (Daryl)]

You may also want to look at the Statistics integration as well.

Statistics

[maisun]

Thank you!
There are both short term and long term statistics, I think I just need 10 days so short term works, however z my data changes per hour, or per day, so I don’t need the 5-minutes statistics - what would be the best approach?
Sorry for the naive question