Pat, I have the graphs of each month compared to the historical average of
that month and that of each year compared to the historical average of all
the years.
I have modified line 1571 of belchertown.py with 2 queries.
if observation == 'rainAvg':
if xaxis_groupby == "year":
sql_lookup = 'SELECT strftime("{0}", datetime(dateTime,
"unixepoch")) as {1}, (select sum(rain)/count
(DISTINCT(strftime("%Y",datetime,"unixepoch"))) from archive) as obs from
archive WHERE dateTime >= {4} AND dateTime <= {5} GROUP BY {6};'.format(
strformat, xaxis_groupby, aggregate_type, obs_lookup, start_ts, end_ts,
xaxis_groupby )
else:
sql_lookup = 'SELECT strftime("{0}", datetime(dateTime,
"unixepoch")) as {1},
IFNULL({2}({3}),0)/count(DISTINCT(strftime("%Y",datetime,"unixepoch"))) as
obs from archive WHERE dateTime >= {4} AND dateTime <= {5} GROUP BY
{6};'.format( strformat, xaxis_groupby, aggregate_type, obs_lookup,
start_ts, end_ts, xaxis_groupby )
else:
sql_lookup = 'SELECT strftime("{0}", datetime(dateTime,
"unixepoch")) as {1}, IFNULL({2}({3}),0) as obs FROM archive WHERE dateTime
>= {4} AND dateTime <= {5} GROUP BY {6};'.format( strformat, xaxis_groupby,
aggregate_type, obs_lookup, start_ts, end_ts, xaxis_groupby )
Y los graficos son estos:
I think that for this type of graphics you had to put an option to only
generate them once a week or so because they do not vary anything between
them and load the raspberry.
--
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/ff29a405-adb0-40b9-ae29-ad0e3dcf72e2%40googlegroups.com.
