webartoli
July 17, 2023, 8:00am
1
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.
webartoli
July 17, 2023, 8:33am
2
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
tom_l
July 17, 2023, 8:55am
3
Which integration are you using to get your sensors in to Home Assistant?
webartoli
July 17, 2023, 10:52am
4
webartoli
July 17, 2023, 12:47pm
5
Find an issue in solarman integration, proposing a PullRequest here.
StephanJoubert:main ← webartoli:main
opened 12:45PM - 17 Jul 23 UTC
Actually the `hyd-zss-hp-3k-6k` inverter definition has marked all "Today" total… izer with
``` yaml
state_class: 'total'
```
This cause a big diff on 1st measure of each day.
According to [docs](https://developers.home-assistant.io/docs/core/entity/sensor/#available-state-classes) and other inverter definition this sensor need to be.
``` yaml
state_class: 'total_increasing'
```
1 Like
