Sorry Tom, I got a little confused because first I thought that the value UVI 0.856 was in the archive_day_UV and not archive and UVI 1.05 in archive instead of archive_day_UV. Therefore it's right like you told me, because I know that the LOOP packets values can be higher for daily summary.
What I don't understand is why I'm getting the UVI 0.856 for All Time and not the higher of UVI 1.05. Is there something wrong in my formulas? $alltime.UV.max = I get 0.856 $year.UV.max =I I get 1.05 Il giorno martedì 9 novembre 2021 alle 20:19:16 UTC+1 [email protected] ha scritto: > 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/0a5dec6c-c98c-41dd-8331-2b5592d062een%40googlegroups.com.
