How can I calculate a max per period of maximums per day
I'm looking for a solution regarding the following problem. For a number of intervals a day I'm calculating a sum, in another expressions i'm calculating the maximum score of those intervals. Now I would like to know the maximum score for a particular period (in my case periods are months).
Using the sum to determine the score per day makes the maximum expression useless when not using the date dimension (since I do want the maximum per day score). The score I would like to get in the example is 4 (so far I'm getting 6 > maximum of the sum of interval 3). Any suggestions? (If there is a better solution for finding the maximum score per day this would be helpfull as well).