Hourly consumption widely off compared to the statistic

[jovial lily]

Hi, I recently added some PDUs and power measuring plugs in my homelab and want to track consumption and cost in Home Assistant.
I've created two sensors from templates:

• Total Energy: A sensor with total_increasing that sums the consumption of all individual devices. Unit is Wh and compared to my devices seems to be correct.
• Total Energy kWh: A sensor that takes the Total Energy sensor and multiplies by 1000 to get kWh. I created this sensor becuse I had the same problem when I used the Total Energy sensor directly in the energy panel. I suspected that the Wh unit may not be supported but it seems that both Wh and kWh have the same problem.

My daily consumption is between 2-4 kWh. This equates to 2000-4000Wh. However, the energy panel is showing me between 500kWh to 600kWh consumption per hour. This widely skews the cost calculations and makes the panel useless to me.

The panel uses the Total Energy statistic at the moment (visible in the first screenshot).

Does anyone know what's going on here?

[tawdry compass]

Your sensor is fucked
It jumping up and down like that is making it read +2kWh and then treats the strep down as a reset.

Also you need to divide Wh by 1000 to get kWh, not multiply

[jovial lily]

Ah sorry, I meant divide - not multiply. I'll look into why it's jumping.

Seems like the total was calculated incorrectly. I fixed the template and deleted the history using the Recorder. Will now wait for data to accumulate and see whether it fixed that. Thank you