I think that the query is not executed. in the graph i have. It's with the
belchertown skin.
[temperaturas]
time_length = all
#aggregate_type = max
aggregate_interval = year
type = column
observation_type = outTemp
[[dias_a_mas_25_ano]]
El viernes, 5 de mayo de 2023 a las 16:54:48 UTC+2, [email protected]
escribió:
> 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/4f6c6c87-fdb4-4547-a5e8-9ef6f20387c7n%40googlegroups.com.
