Hello all, would like to ask for help,
I have two tables:
* date table
* table called total, in this table there is a column 'max.temp.' which contains daily max. temp. since 1951
I would like to visualize the following in a matrix/table.
By year - number of heatwaves - startdate / enddate of this heatwave - duration in days - average temp during this heatwave.
If there are multple heatwaves in one year, show them on different rows in the matrix/table.
(edit 11-6-23!)
A heatwave is a serial of (at least) 5 days in a row where max.temp. >=25 AND within this period there are also 3 days in a row where max.temp. >= 30.
Don't know how to handle this ... columns / meausures / combination??
Any help would be appreciated, thanks in advance.
Best regards, RG
