This is messing up my rain calculations as I use yearly accumulated rain to avoid data loss across day boundaries, and we run on water year, which is October 1-September 30 here in the Pacific Northwest US. I have tried running a database reconstruction and rebooting with no change.
In my template [rain0total-yearsum=.2:--] is returning 462.00, it should return 917.20.
Querying the database directly, you can see the template is returning the calendar year sum and not the water year sum:
Code: Select all
sqlite> select sum(val) from rain0total_hour where ts > strftime('%s', '2026-01-01 00:00:00');
sum(val)
--------
462000
sqlite> select sum(val) from rain0total_hour where ts > strftime('%s', '2025-10-01 00:00:00');
sum(val)
--------
917200
Also as a note, I guess you can't directly edit the yearly rainfall like you can on the storage-less models. I had to export the rain amounts from my main observations database and upload them to the PRO2 to get any sum at all. Luckily this is the dry time of year so rain isn't changing a whole lot.
