if i put $day.outTemp.days_more_25_year then i get the days at more 25 this year but in the graph [days_more_25_year] not show nothing.
El viernes, 5 de mayo de 2023 a las 16:52:53 UTC+2, [email protected] escribió: > I made days_more_25_year = "SELECT count(*) FROM archive_day_outTemp WHERE > STRFTIME('%Y', dateTime,'unixepoch','localtime') = '{year:04d}' AND > max>25;" but the graph is empty. I don´t understand because you say that I > need GROUP BY. The query must return one row only. One row by year. right? > > El viernes, 5 de mayo de 2023 a las 15:23:20 UTC+2, Tom Keffer escribió: > >> Yes, the option data_type can actually be any SQL SELECT expression, but >> to do what you want you'll need a GROUP BY expression as well. That's why >> you'll need an xtype extension. >> >> Still, give it a try! >> >> On Fri, May 5, 2023 at 5:43 AM [email protected] <[email protected]> wrote: >> >>> OK. Thank you. I thinked that it was a option in the graps section to do >>> this, something like condition=outTemp>25. Would be a interesting option. >>> >>> El viernes, 5 de mayo de 2023 a las 13:56:17 UTC+2, Tom Keffer escribió: >>> >>>> The NOAA reports do this in a tabular form, but if you want to graph >>>> the results, you would have to write a custom aggregation using the >>>> xtype <https://github.com/weewx/weewx/wiki/xtypes> system. >>>> >>>> See the xtype extension weewx-xaggs >>>> <https://github.com/tkeffer/weewx-xaggs> for an example that is fairly >>>> close to your requirements. It does plots of historical min and max for >>>> each day. >>>> >>>> On Fri, May 5, 2023 at 1:53 AM [email protected] <[email protected]> >>>> wrote: >>>> >>>>> Yes i have time lenght but i want a graph with the count of days for >>>>> month in this year or other that the temperature is above than 25º. That >>>>> is >>>>> to say, group the temperatures by month and then count how many days in >>>>> that month there was a temperature greater than 25º >>>>> ex: >>>>> month-day with temperature above 25 >>>>> Jan-0 >>>>> feb-0 >>>>> mar-2 >>>>> apr-4 >>>>> may-6 >>>>> i don't know where to put the condition outTemp>25 >>>>> >>>>> El viernes, 5 de mayo de 2023 a las 3:39:04 UTC+2, Tom Keffer escribió: >>>>> >>>>>> Not following your question. >>>>>> >>>>>> Have you tried option time_length >>>>>> <http://www.weewx.com/docs/customizing.htm#Plot_scaling_options>? >>>>>> >>>>>> On Thu, May 4, 2023 at 3:05 PM [email protected] <[email protected]> >>>>>> wrote: >>>>>> >>>>>>> the days for month in this year. >>>>>>> How can conditions be set? >>>>>>> >>>>>>> -- >>>>>>> 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/c3daa311-f54d-4b34-8f44-8869d0068033n%40googlegroups.com >>>>>>> >>>>>>> <https://groups.google.com/d/msgid/weewx-user/c3daa311-f54d-4b34-8f44-8869d0068033n%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/1188b26f-f9be-424b-b618-4630fb02f17en%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/1188b26f-f9be-424b-b618-4630fb02f17en%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/de87f635-49a4-4e5e-95a5-a28179ac64den%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/de87f635-49a4-4e5e-95a5-a28179ac64den%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/20fa1dd1-161f-4638-9e40-3a761575edf1n%40googlegroups.com.
