Yes that year to date sum worked for what I need or am seeking. I tried to use MONTH instead of year and adjust the 01 01 parameters but no joy with that. need to find ref manual for the mariahdb/mysql syntaxes and without a big picture view of data relationships it will be a bit of a challenge methinks but thanks for your help here on the YTD part anyway.
On Wednesday, July 10, 2019 at 7:23:37 AM UTC-5, Andrew Milner wrote: > > if the year select works as you need then I am sure you can google for the > month adaption!!!! > > > > On Wednesday, 10 July 2019 15:03:48 UTC+3, CCOR58 RADIO wrote: >> >> I am looking for the current calendar month and the current calendar year >> running accumulations >> >> >> On Wednesday, July 10, 2019 at 6:38:05 AM UTC-5, 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/44d68dfb-90b2-4ac6-99fd-a784bc75668b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
