I don't see why your approach would not work, although you have a syntax
error in your calls to strftime(). There cannot be a space between the '%'
and the time modifier. It should look something like this:
select avg (outtemp) from archive where strftime ('%m %d %H', datetime,
'unixepoch') = strftime ('%m %d %H', 'now')";
I'm not sure what you mean by "xaggs labels", but if you mean the $day tag,
then, yes, it is indeed aggregating over one day.
On Fri, Dec 10, 2021 at 9:14 AM [email protected] <[email protected]> wrote:
> I had not seen the points on the weekly chart.
> Then the only thing that doesn't work is the daily chart because when
> adding aggregate_interval = day or hour it gives an error and this is the
> one that interests me the most.
> I wanted to make a graph with the historical temperature of the current
> moment and the current temperature. For this I had created an sql in xaggs:
> 'historical_temp': "select avg (outtemp) from archive where strftime ('%
> m-% d% H', datetime, 'unixepoch') = strftime ('% m-% d% H', 'now')",
> Can you think of a way to do it?
> I understand that in the case of xaggs labels, aggregation should not be
> necessary since it only gives one data per day. Unless we group by weeks or
> months.
> El viernes, 10 de diciembre de 2021 a las 14:28:55 UTC+1, [email protected]
> escribió:
>
>> Sorry, I was looking for user.xaggs.XAggsService at the end of
>> xtype_services.
>>
>> Yes, an aggregation type and an aggregation interval must always be
>> specified together. Otherwise, they wouldn't mean anything.
>>
>> The aggregation interval must always be one day. I'll amend the
>> documentation to make that clear.
>>
>> If you look closely at your weekly chart, you'll see that it is indeed
>> showing dots for the historical data --- it's just that they are not
>> connected. See the section "Dots in the plots
>> <http://www.weewx.com/docs/usersguide.htm#dots_in_plots>" in the User's
>> Guide.
>>
>> Yes, I am the author of XAggs.
>>
>> On Fri, Dec 10, 2021 at 4:40 AM [email protected] <[email protected]>
>> wrote:
>>
>>> I think at least one problem is that aggs tags have no aggregation. They
>>> simply give one data per day. The problem is that imagegenerator.py doesn't
>>> support aggregation_type without aggregation_interval.
>>> I have tried with None and it is the same as if I don't put
>>> aggregation_interval.
>>> Give a message:
>>> Aggregate interval required for aggregate type historical_min
>>> What I don't understand is its different behavior in the weekly charts,
>>> it doesn't paint anything and in the monthly charts it does.
>>> Are you the author of xagss?
>>>
>>> El viernes, 10 de diciembre de 2021 a las 12:53:08 UTC+1,
>>> [email protected] escribió:
>>>
>>>> I have tested the chart you posted and it is very strange. The only
>>>> place it works is putting it in monthly charts like the one you sent.
>>>> In the weekly chart, the chart that I sent before appears where neither
>>>> the min nor the historical max appear only outTemp
>>>> And if I put it on the daily chart and putting aggregation_period =
>>>> hour it produces the same error that I showed before with the exception
>>>> **** weewx.UnknownType: outTemp
>>>>
>>>> El viernes, 10 de diciembre de 2021 a las 11:28:34 UTC+1,
>>>> [email protected] escribió:
>>>>
>>>>> But it does. It is the first of the line xtypes_services
>>>>> xtype_services = user.xaggs.XAggsService ,
>>>>> weewx.wxxtypes.StdWXXTypes, weewx.wxxtypes.StdPressureCooker,
>>>>> weewx.wxxtypes.StdRainRater, weewx.wxxtypes.StdDelta
>>>>> Also I can use its historical_max, historical_min ... tags on the web
>>>>> page with $day.outTemp.historical_min
>>>>> And skin.conf is stock unless I change to make this chart
>>>>>
>>>>>
>>>>> El viernes, 10 de diciembre de 2021 a las 0:17:28 UTC+1,
>>>>> [email protected] escribió:
>>>>>
>>>>>> I would like to see skin.conf as well, but, no matter, your
>>>>>> xtype_services section does not include 'user.xaggs.XAggsService'. See
>>>>>> an earlier
>>>>>> email
>>>>>> <https://groups.google.com/g/weewx-user/c/NCuKcrFTPkQ/m/uGiWUrENAQAJ>
>>>>>> in this thread. It should read
>>>>>>
>>>>>> xtype_services = user.xaggs.XAggsService,
>>>>>> weewx.wxxtypes.StdWXXTypes, weewx.wxxtypes.StdPressureCooker,
>>>>>> weewx.wxxtypes.StdRainRater, weewx.wxxtypes.StdDelta,
>>>>>> user.xaggs.XAggsService
>>>>>>
>>>>>> (all on one line).
>>>>>>
>>>>>> On Thu, Dec 9, 2021 at 2:49 PM [email protected] <[email protected]>
>>>>>> wrote:
>>>>>>
>>>>>>> El jueves, 9 de diciembre de 2021 a las 23:34:32 UTC+1,
>>>>>>> [email protected] escribió:
>>>>>>>
>>>>>>>> Hmmm. It certainly works for me.
>>>>>>>>
>>>>>>>> Can you post your copy of skin.conf, and the [Engine] section of
>>>>>>>> weewx.conf? I'll use them on my end and see if I can reproduce your
>>>>>>>> result.
>>>>>>>>
>>>>>>>> On Thu, Dec 9, 2021 at 2:29 PM [email protected] <[email protected]>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> More than ten. I insist that if I use
>>>>>>>>> $day.outTemp.historical_min it works and give me a number
>>>>>>>>>
>>>>>>>>> El jueves, 9 de diciembre de 2021 a las 23:27:56 UTC+1,
>>>>>>>>> [email protected] escribió:
>>>>>>>>>
>>>>>>>>>> Perhaps you don't have enough data? How many years of data in
>>>>>>>>>> your database?
>>>>>>>>>>
>>>>>>>>>> On Thu, Dec 9, 2021 at 2:26 PM [email protected] <[email protected]>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Yes. I have user.xaggs.XAggService in xtype_services in
>>>>>>>>>>> weewx.conf
>>>>>>>>>>>
>>>>>>>>>>> El jueves, 9 de diciembre de 2021 a las 23:19:34 UTC+1,
>>>>>>>>>>> [email protected] escribió:
>>>>>>>>>>>
>>>>>>>>>>>> Did you add 'user.xaggs.XAggsService' to the end of
>>>>>>>>>>>> xtype_services, as mentioned in an earlier email in this thread?
>>>>>>>>>>>>
>>>>>>>>>>>> On Thu, Dec 9, 2021 at 2:18 PM [email protected] <
>>>>>>>>>>>> [email protected]> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> The problem was I had put that section on the day charts. If i
>>>>>>>>>>>>> put in week or month there no errors but it don't plot anything.
>>>>>>>>>>>>> [image: weekhistorical.png]
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>>>>>> --
>>>>>>>>>>>>> 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/96003050-8169-41b4-91cc-9dadf59aed18n%40googlegroups.com
>>>>>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/96003050-8169-41b4-91cc-9dadf59aed18n%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/5e2ac174-f98b-47ea-a4a1-cce3ceae565cn%40googlegroups.com
>>>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/5e2ac174-f98b-47ea-a4a1-cce3ceae565cn%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/a5b1bd4a-dc42-44e0-a7a7-256215106348n%40googlegroups.com
>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/a5b1bd4a-dc42-44e0-a7a7-256215106348n%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/ba71942e-d16c-4c3a-a0cd-352d1fef25f5n%40googlegroups.com
>>>>>>> <https://groups.google.com/d/msgid/weewx-user/ba71942e-d16c-4c3a-a0cd-352d1fef25f5n%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/08a26d42-1f89-4bf5-991c-225d7a39bc74n%40googlegroups.com
>>> <https://groups.google.com/d/msgid/weewx-user/08a26d42-1f89-4bf5-991c-225d7a39bc74n%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/023a50f2-aa2e-4c75-b298-53fb0b207558n%40googlegroups.com
> <https://groups.google.com/d/msgid/weewx-user/023a50f2-aa2e-4c75-b298-53fb0b207558n%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/CAPq0zECf%3DUtqdti%3DASqGJeCwDi2WY1%3DrgyQo4Z%2B50Cczw_LGnw%40mail.gmail.com.
