Show consumed energy for a specific interval, grouped by hour

Configuration Frontend
1

Hello,

In the day view the “Energy usage” graph shows the chart grouped by hour. If I switch to an interval, the “Energy usage” graph shows the data grouped by day.

I’m trying to find a way to see how much energy I used every hour interval in that specific period.

How sure how useful this is for others, but for me I can choose my power plan, which can be “free nights”, or “free night and weekends”, but more expensive the rest of the day.

Since we already have the data I think it would be useful to be able to get the option to get this data easier than going every day of the month and getting the stats.

Is there a way to get this? Other than maybe going to the DB to query the data.

Thank you.

2

https://www.home-assistant.io/dashboards/statistics-graph/

3

Thanks, I looked at that, but I don’t see a way to achieve that using the statistics-graph

The best I could come up with was:

chart_type: bar
period: hour
type: statistics-graph
entities:
  - sensor.energy_meter_electric_consumed_kwh
stat_types:
  - change
days_to_show: 14

Which generated something like:
image

4

Then I don’t understand what you want. I thought that was exactly what you asked for. Hourly binned energy, for any period of time.

5

I’m thinking they want a graph with exactly 24 columns, one for each hour of the day, and each one would be the summation of all the energy used within that time period of every day that is selected in the range.

So for a range of 3 days, the 1pm column would be the total energy used from 1-2pm on the first, second, and third day.

6

Exactly as @mekaneck mentioned.
Currently I see:

image
image1878×591 46 KB

7

and:

image
image1856×552 47.2 KB

8

I’m looking for something like:

image
image617×603 29.6 KB

But instead of entities, it’s days.

I hope this makes more sense.