I’m more and more working myself into Home Assistant. Currently I’m running lots of Z-Wave devices connected to a Rpi4 Z-Pi 7 board. I’m using some energy meters by Devolo, which when freshly included reported some unplausible spikes in consumption (to the tune of more than 150 MW for 1 second), which I since removed through SQL queries. The graph now looks fine for the entity itself when selecting the period from the start and the db shows plausible entries for total consumption as well (currently a bit over 11 kWh).
However, when taking a look at the energy dashboard, the values for day & week are correct and plausible, but when switching to month, suddenly not 11 kWh are reported, but close to 300. Since I don’t think that this is extrapolated, I would expect the total to be also something around 11 kWh for 2 weeks of use.
Can someone point me to a SQL query, which will show me, why the total for the whole month is so high, while the total in the database is correct? When querying the db I don’t find any values out of tune anymore.