sqlite> select avg(outTemp) from archive where strftime("%Y-%m",
dateTime,'unixepoch','localtime')=='2020-11';
51.117818676717
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).
[email protected] 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 <[email protected]> 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 [email protected].
>> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/87243ab4-47a4-4c85-b004-530f84e77673n%40googlegroups.com.
