MariaDB [homeassistant]> select state,sum,from_unixtime(created_ts) from statistics_short_term where metadata_id=8 order by id;
…
| 22.4 | 200.90000000000003 | 2023-10-18 21:55:10.233322 |
| 22.4 | 200.90000000000003 | 2023-10-18 22:00:10.218998 |
| 0 | 206.10000000000005 | 2023-10-18 22:05:10.215252 |
| 0 | 206.10000000000005 | 2023-10-18 22:10:10.215664 |
So, what we see here is the short term statistics table and we see from row 2 to 3 that the sum grows from 200.90 to 206.10 while the state value resets to zero. I can not see why this would be the case. The sum should increase by current state minus last state if current state is larger than last state.
The sensor in question is a sensor group with the sum aggregate. All group member sums behave as expected and don’t show this effect. Only the group itself.
This seems like a bug - or am I missing something?
Any input is appreciated.
Thx
Tim