As I mentioned in my first note, I'm not surprised the value from the daily summary is higher --- that's because it includes transient values from the LOOP packets.
Don't know what you mean by "on my website it's totally the opposition." How can you tell the difference? On Tue, Nov 9, 2021 at 10:39 AM Mauro De Lauretis < [email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/weewx-user/389c7ce7-b21f-4b6b-ae3f-60ef97c8a68dn%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/CAPq0zEArTXsVo_CsrL%3DE74LwYgUe5ocmT2eeQ15Y-nP1WyKKdA%40mail.gmail.com.
