I am observing the same situation, as well as other WeeWX users near me. The average is clearly off since the 4.2.0 update. It also affects yearly average since then. So I guess this is something that happened with the 4.2.0 Version. I don't want to rebuild my daily values, how to find the bad values and correct them? Probably in the archive_daily table of the day I made the update?
I found something: It's a change with "sum": 1-13 has "new" sumtime, 14 a mix (the day I updated) and old sumtime are 15 and and older: Isn't there a config that sets how this is calculated? b.cl...@gmail.com schrieb am Donnerstag, 19. November 2020 um 19:43:57 UTC+1: > Yeah, everything looks great again. > Thank you Tom for that excellent support. > Greetings from Suedlohn (Germany). > Berny > > tke...@gmail.com schrieb am Donnerstag, 19. November 2020 um 17:56:56 > UTC+1: > >> So, for some reason, the weighted sum (field 'wsum') has too high a >> value, or the sum of observation time (field 'sumtime') has too low a value. >> >> The easiest fix is to just rebuild the daily summaries using the >> wee_database >> utility <http://www.weewx.com/docs/utilities.htm#wee_database_utility>. >> >> Stop weewxd. then, >> >> *wee_database --drop-daily* >> *wee_database --rebuild-daily* >> >> Restart weewxd >> >> For a database of your size, it shouldn't take more than a minute or two. >> >> It could take some time for the NOAA and html files to get corrected. You >> can speed things up by deleting them and allowing weewx to regenerate them. >> >> -tk >> >> >> >> On Thu, Nov 19, 2020 at 8:48 AM Berny Cl <b.cl...@gmail.com> wrote: >> >>> sqlite> select sum(wsum)/sum(sumtime) from archive_day_outTemp where >>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11'; >>> 60.1308595259353 >>> >>> Ok, that looks the same like the value in my history table. >>> >>> tke...@gmail.com schrieb am Donnerstag, 19. November 2020 um 17:13:38 >>> UTC+1: >>> >>>> 1. That looks reasonable. One other query to try: >>>> >>>> sqlite> *select sum(wsum)/sum(sumtime) from archive_day_outTemp where >>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11';* >>>> >>>> 2. If that doesn't reveal anything, I will send you an instrumented >>>> version of xtypes.py that will log the calculation. >>>> >>>> >>>> On Thu, Nov 19, 2020 at 6:44 AM Berny Cl <b.cl...@gmail.com> wrote: >>>> >>>>> sqlite> select avg(outTemp) from archive where strftime("%Y-%m", >>>>> dateTime,'unixepoch','localtime')=='2020-11'; >>>>> 51.117818676717 <(781)%20867-6717> >>>>> sqlite> select sum(sum)/sum(count) from archive_day_outTemp where >>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11'; >>>>> 51.114923603352 >>>>> >>>>> Thank you! >>>>> OK, I did that. The two numbers are very close. I think they are >>>>> correct (in Fahrenheit) but in my history table the temperature ist too >>>>> high (in degree Celsius). >>>>> >>>>> tke...@gmail.com schrieb am Donnerstag, 19. November 2020 um 15:02:55 >>>>> UTC+1: >>>>> >>>>>> Most likely it's some bad data. Let's check the database directly. >>>>>> >>>>>> First find the database. If you did a package install, it's most >>>>>> likely at /var/lib/weewx/weewx.sdb. If you did a setup.py install, it's >>>>>> at >>>>>> /home/weewx/archive/weewx.sdb. Let's assume the former. >>>>>> >>>>>> Then, run two queries: >>>>>> >>>>>> *sqlite /var/lib/weewx/weewx.sdb* >>>>>> sqlite> *select avg(outTemp) from archive where strftime("%Y-%m", >>>>>> dateTime,'unixepoch','localtime')=='2020-11';* >>>>>> sqlite> *select sum(sum)/sum(count) from archive_day_outTemp where >>>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11';* >>>>>> >>>>>> The first method calculates the average temperature for Nov 2020 by >>>>>> using the main archive table. The second by using the daily summaries. >>>>>> The >>>>>> two numbers should be very close. See what you get and we'll take it >>>>>> from >>>>>> there. >>>>>> >>>>>> -tk >>>>>> >>>>>> >>>>>> On Thu, Nov 19, 2020 at 4:43 AM Berny Cl <b.cl...@gmail.com> wrote: >>>>>> >>>>>>> Hi everybody, >>>>>>> since the last update to version 4.20, i have noticed an incorrect >>>>>>> value for the monthly average temperature at the history table and also >>>>>>> in >>>>>>> the monthly NOAA table. >>>>>>> I use the niculskin and my station is a FineOffset (WS 1080). >>>>>>> >>>>>>> See at: http://haus-volmering.de/history.html >>>>>>> (Durchschnittstemperatur = Average Temperature for Nov is obviously >>>>>>> incorrect) >>>>>>> >>>>>>> How can I fix that? >>>>>>> >>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "weewx-user" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to weewx-user+...@googlegroups.com. >>>>>>> To view this discussion on the web visit >>>>>>> https://groups.google.com/d/msgid/weewx-user/277ec811-21b4-41e9-8fc1-cda38d87014dn%40googlegroups.com >>>>>>> >>>>>>> <https://groups.google.com/d/msgid/weewx-user/277ec811-21b4-41e9-8fc1-cda38d87014dn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> >>>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "weewx-user" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to weewx-user+...@googlegroups.com. >>>>> >>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/weewx-user/87243ab4-47a4-4c85-b004-530f84e77673n%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/87243ab4-47a4-4c85-b004-530f84e77673n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "weewx-user" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to weewx-user+...@googlegroups.com. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/weewx-user/f5a4768c-27f7-49c6-807e-496296d0c380n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/f5a4768c-27f7-49c6-807e-496296d0c380n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/11e8f2a7-e19c-4942-9306-9db0c4dfcc31n%40googlegroups.com.
