Mismatch between actual and reported energy usage timing

[Scheffie]

Today I discovered a mismatch in the timing fro the actual used energy (recoderd by P1 meter) and the energy reported by the integration.

Here you can see that the DHW heated between 12-13hr:

This is the graph of the daily power usage for the DHW heating:

Monthly and yearly counters show the increase at the same time..

What could be wrong/reason for this mismatch? This causes "confusion" in the energy overview:

First at 12-13hr 2kw is reported as undefined used (positive), Later the 2kw are reported as undefined returned (negative)

The Onecta app on my iphone reports the usage at the correct time:

[jwillemsen]

For your energy dashboard you can better use the yearly energy consumption, the daily increments at the moment the new value is received, which could be outside of the block due to the polling and how daikin reports this, see https://developer.cloud.daikineurope.com/docs/84e709f1-9d33-47e1-a93c-7f5cb8b8f12b/supported_features/supported_features_climatecontrol#doc-heading-energy-consumption-data

[Scheffie]

My energy panel configuration for DHW for example is: sensor.verwarming_domestichotwatertank_heating_yearly_electrical_consumption

As I mentioned in the first post, the time of increase in day/month/year counter is at the same time.

[jwillemsen]

The daikin provided energy consumption is only updated in steps of 1 and HA assigns the increment to the time where it receives the increment, this could be an hour or even 2 earlier, Daikin says Consumption data is expected to be updated every 2 hours, randomized from the startup time of the Daikin device. This means that, for example, data d[0] will be available between 02:00 & 04:00., so the energy usage for 00:00-02:00 is updated in HA somewhere between 02:00-04:00

[Scheffie]

Thanks for clarifying this! I think I need a real power monitor on my Daikin to clean up my energy graph

[jwillemsen]

Yes, installing a separate kWh meter is the best solution

[Staartvin]

I'm running into the same issue. Any recommendations for separate power meters considering my heat pump uses a three-phase power connection?

[jwillemsen]

I am using the meters from https://www.homewizard.com/

[Staartvin]

I've ran into the same issue. I'm aware that a separate power meter is the best option for reading data of my Daikin heatpump, but I'm also looking into using a combination of utility, derivative and integration sensor in Home assistant to compute the smoothed power consumption over time. I'm not sure if that will help the energy dashboard though.

[Purch]

I needed a similar view that is in daikin onecta app. So with SQL addon few template sensors. Also fixes the time issue on data reporting. So between 4 and 6 Max value is assigned to 02:00. Tested 1h splitting of data rows, but 2h is nicer.

final query 2h.sql
my_template.yaml