Energy Dashboard Peak 1st hour of the day

Hello guys, I’ve replaced my solar panel inverter and I’m trying to integrate the new-one with energy panel.

The Integration gives me a lot of useful sensor in kwh:

  • Energy Selling Today
  • Energy Purchase Today
  • Energy Generation Today
  • Battery Discharge Today

That are working great and they are resetting at midnight.

So seems that I don’t need helpers anymore, BUT energy dashboard is broken: each day in the first hour there is a peak of all sensors that broke all dashboard stats.

I’m trying to figure out what is going wrong.
Is someone hitting the same issue ?

Some additional details that my be helpful.

Trying to figure out the reason I’ve queried the stats table as follows.

SELECT
, DATETIME(created_ts, 'unixepoch', 'localtime') as created_ts
, DATETIME(start_ts, 'unixepoch', 'localtime') as start_ts
, state
, round(sum,2) as sum
FROM 
  statistics 
JOIN 
  statistics_meta
ON 
  statistics.metadata_id = statistics_meta.id
WHERE 
  statistic_id like '%_energy_purchase_today'
ORDER BY
  statistic_id, created_ts

And this is the results for a sensor

created_ts start_ts state sum
2023-07-15 16:00:10 2023-07-15 15:00:00 0.53 0.01
2023-07-15 17:00:10 2023-07-15 16:00:00 0.53 0.01
2023-07-15 18:00:10 2023-07-15 17:00:00 0.53 0.01
2023-07-15 19:00:10 2023-07-15 18:00:00 0.54 0.02
2023-07-15 20:00:10 2023-07-15 19:00:00 0.55 0.03
2023-07-15 21:00:10 2023-07-15 20:00:00 0.57 0.05
2023-07-15 22:00:10 2023-07-15 21:00:00 0.57 0.05
2023-07-15 23:00:10 2023-07-15 22:00:00 0.57 0.05
2023-07-16 00:00:10 2023-07-15 23:00:00 0.58 0.06
2023-07-16 01:00:10 2023-07-16 00:00:00 0.0 -0.52
2023-07-16 02:00:10 2023-07-16 01:00:00 0.0 -0.52
2023-07-16 03:00:10 2023-07-16 02:00:00 0.02 -0.5
2023-07-16 04:00:10 2023-07-16 03:00:00 0.03 -0.49
2023-07-16 05:00:10 2023-07-16 04:00:00 0.05 -0.47
2023-07-16 06:00:10 2023-07-16 05:00:00 0.07 -0.45
2023-07-16 07:00:10 2023-07-16 06:00:00 0.09 -0.43
2023-07-16 08:00:10 2023-07-16 07:00:00 0.1 -0.42
2023-07-16 09:00:10 2023-07-16 08:00:00 0.11 -0.41
2023-07-16 10:00:10 2023-07-16 09:00:00 0.13 -0.39
2023-07-16 11:00:10 2023-07-16 10:00:00 0.15 -0.37
2023-07-16 12:00:10 2023-07-16 11:00:00 0.17 -0.35
2023-07-16 13:00:10 2023-07-16 12:00:00 0.21 -0.31
2023-07-16 14:00:10 2023-07-16 13:00:00 0.22 -0.3
2023-07-16 15:00:10 2023-07-16 14:00:00 0.23 -0.29
2023-07-16 16:00:10 2023-07-16 15:00:00 0.27 -0.25
2023-07-16 17:00:10 2023-07-16 16:00:00 0.27 -0.25
2023-07-16 18:00:10 2023-07-16 17:00:00 0.28 -0.24
2023-07-16 19:00:10 2023-07-16 18:00:00 0.29 -0.23
2023-07-16 20:00:10 2023-07-16 19:00:00 0.3 -0.22
2023-07-16 21:00:10 2023-07-16 20:00:00 0.32 -0.2
2023-07-16 22:00:10 2023-07-16 21:00:00 0.33 -0.19
2023-07-16 23:00:10 2023-07-16 22:00:00 0.33 -0.19
2023-07-17 00:00:10 2023-07-16 23:00:00 0.33 -0.19
2023-07-17 01:00:10 2023-07-17 00:00:00 0.01 -0.51
2023-07-17 02:00:10 2023-07-17 01:00:00 0.03 -0.49
2023-07-17 03:00:10 2023-07-17 02:00:00 0.05 -0.47
2023-07-17 04:00:10 2023-07-17 03:00:00 0.06 -0.46
2023-07-17 05:00:10 2023-07-17 04:00:00 0.08 -0.44
2023-07-17 06:00:10 2023-07-17 05:00:00 0.1 -0.42
2023-07-17 07:00:10 2023-07-17 06:00:00 0.11 -0.41
2023-07-17 08:00:10 2023-07-17 07:00:00 0.12 -0.4
2023-07-17 09:00:10 2023-07-17 08:00:00 0.14 -0.38
2023-07-17 10:00:10 2023-07-17 09:00:00 0.16 -0.36

Which integration are you using to get your sensors in to Home Assistant?

I’m using StephanJoubert/home_assistant_solarman installed via HACS with my inverter definition hyd-zss-hp-3k-6k.yaml.

I have not thinked that the integration could cause this issue, but it seems that I’m not alone.
Avoid reset of yesterdays daily production in diagram · Issue #66 · StephanJoubert/home_assistant_solarman · GitHub.

Find an issue in solarman integration, proposing a PullRequest here.

1 Like