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/0fabcafe-cb69-4362-bb56-d6f38e61d0c3n%40googlegroups.com.
