EDIT: I’ve chosen the wrong database before. They don’t mach! UV 0.856 on archive and 1.05 on archive_day, but on my website it’s totally the opposite
Il giorno martedì 9 novembre 2021 alle 19:31:28 UTC+1 Mauro De Lauretis ha scritto: > Hi Tom! > > Thank you for your answer. > Yes, I have a match for both at > > 2020-12-09 07:00:00 > > But there I had no sensor and the values are on UVI 0 of course. > > > Il giorno martedì 9 novembre 2021 alle 19:17:47 UTC+1 [email protected] ha > scritto: > >> No explanation. Usually the values from the daily summaries are higher >> than those from the archive table because they also include transient >> values from the LOOP packets. >> >> But, let's double check. run these queries: >> >> *select from_unixtime(dateTime), UV from weewx.archive order by UV desc >> limit 1;* >> *select from_unixtime(maxtime), max from weewx.archive_day_UV order by >> max desc limit 1;* >> >> Do they match? >> >> On Tue, Nov 9, 2021 at 9:58 AM Mauro De Lauretis <[email protected]> >> wrote: >> >>> Hi all >>> >>> Today I was looking better to my MySQL database and I was wondering why >>> my showed all-time data is always lower than my max observed data. >>> >>> Let me explain it better taking an example from UV Sensor: >>> >>> In the archive table, the max observed value is 1.1 UVI and it's >>> currently the highest value I got since I've installed the sensor. But if I >>> take a look on archive_day_UV, the highest value from today and taken for >>> the "All-Time" record is 0.9 UVI. >>> >>> Could someone explain me why archive_day takes this value and not 1.1? >>> >>> Greetings >>> >>> -- >>> 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/85e91c5b-10ff-41bc-84b0-c1c93e5e9bf1n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/85e91c5b-10ff-41bc-84b0-c1c93e5e9bf1n%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/389c7ce7-b21f-4b6b-ae3f-60ef97c8a68dn%40googlegroups.com.
