Welcome to the Cumulus Support forum.

Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080

QueryDayFile

From Cumulus MX version 3 build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since, and has recently released Cumulus MX version 4. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

Post Reply
Mapantz
Posts: 1992
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 11 x64
Location: Dorset - UK
Contact:

QueryDayFile

Post by Mapantz »

I've been reading the md, but I'm not sure I am doing it correctly, or it's not possible?

I'm trying to get the average rain total for each month
Image
weatherbee
Posts: 35
Joined: Sat 16 Mar 2024 7:02 pm
Weather Station: WS-5000
Operating System: Windows 11
Contact:

Re: QueryDayFile

Post by weatherbee »

I would think we would need a tag like <#ByMonthTempAvg mon=[1-12]> which is the mean for requested month over the entire history for temps.
Just need it for rain like <#ByMonthRainAvg mon=[1-12]>
I don't see a way to do it with QueryDayFile.
Tom
Image
User avatar
mcrossley
Posts: 14384
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: QueryDayFile

Post by mcrossley »

No you cannot do that, it is a complex query rather than a simple one.

Even doing it for a single month, say April...
You need to get the totals for each April, then average those totals. So, two steps required.

The day file query tool can only cope with simple single level queries. To do what you ask you would need to write your own SQL query against the database - or use your own external database.
Ulric2
Posts: 47
Joined: Mon 21 Feb 2022 11:30 am
Weather Station: FineOffset
Operating System: Ubuntu 22.04

Re: QueryDayFile

Post by Ulric2 »

Isn't the logic for this already in the NOAA reports? They give monthly rainfall totals.
User avatar
mcrossley
Posts: 14384
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: QueryDayFile

Post by mcrossley »

Well, they read the data files and add up the total for month of the requested report. They do not provide an average by month.
Post Reply