Averages for a month over all time

[michael.k...@gmx.at]

Hello, is there an easy way to get the average of an obs_type for a month defined by it's name?

e.g.: the average for all (completely covered) Septembers in the database:

Example: a database contains data from 2020/09/15 up until now, what's the average September temperature? It is the average of the average September temperature 2021/09, 2022/09, 2023/09, 2024/09. 2020/09 shouldn't be included, because it isn't covered completely.

Is there an easy way to get these values? If yes, how to exclude the current (yet incomplete) month or the first month in the archive, if it isn't completely covered as well?