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
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
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
Moderator: mcrossley
-
weatherbee
- Posts: 35
- Joined: Sat 16 Mar 2024 7:02 pm
- Weather Station: WS-5000
- Operating System: Windows 11
- Contact:
Re: QueryDayFile
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
Just need it for rain like <#ByMonthRainAvg mon=[1-12]>
I don't see a way to do it with QueryDayFile.
Tom
- 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
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.
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
Isn't the logic for this already in the NOAA reports? They give monthly rainfall totals.
- 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
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.