How to calculatate the maximum or minimum daily/monthly/yearly sum of a value?
E.g.: the wettest day of the month (so far)? The wettest month of the year(so far)? The wettest day of the year (so far)? The wettest year? The wettest month of all time? The wettest day of all time?
The dryest day of the month? The
dryest month of the year? The
dryest year? The
dryest month of all time?
And how to exclude the current month, year for these calculations? From the 1st of January's point of view, the current year is probably the dryest year of all time, from the 1st of the current month's view, the current month is probably the dryest of the year, at least ex aequo.