in mysql something like select sum(rain) from archive where dateTime >= UNIX_TIMESTAMP(CONCAT(YEAR(CURDATE()),'-01-01')); might work for the calendar year to date
On Wednesday, 10 July 2019 14:38:05 UTC+3, Andrew Milner wrote: > > 1. You cannot create any additional text on a graph within standard weewx > regardless of what you change > > 2. for the YTD sql statements - is the year you are interested in the > calendar year or the rain year?? Are you using mysql or sqlite3 for your > database?? > > On Wednesday, 10 July 2019 14:17:10 UTC+3, CCOR58 RADIO wrote: >> >> I have managed to get the correct mm units to show in the hourly >> accumulations rain graph. What I would like to be able to have in one of >> the corners of the same graph is a YTD accumulation SUM text figure say in >> bold blue letters and a current calendar month to date rain accumulated >> text SUM figure in RED say adjacent to the YTD one. >> >> What kind of change to the weewx.conf file to I have to do to have this >> show up? >> >> Failing that can anyone pls give me the SQL SELECT statement to use to >> manually extract these numbers from the mysql database using phpmyadmin to >> obtain these two figures? >> >> Thanks >> >> link to graph I would like to try to modify is here: >> http://tr0p0scatter.ca/html/wx-webcam.html >> > -- 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/57ed2c21-6a81-4df5-baa6-f3c431c0a151%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
