Hi, I have problem with my gas meter sensor and long term statistics and tracking energy consumption. I don’t use gas over the summer at all, and when I just started now, the SUM was wrong. I had to recalculate the SUM field in statistics table.
I think the problem is, that the sensor disappears from the statistics_short_term table, because I don’t have any records over more than three months.
Can this be corrected? May be look up in the statistics table, when the sensor has no records in the statistics_short_term?
You should do this in Developer Tools → Statistics rather than editing the db directly.
Not sure about the short to long term stats issue.
Thank you, didn’t know about that.