2 Replies Latest reply: Jun 5, 2013 11:02 AM by Raimund Leussink

# How can I calculate a max per period of maximums per day

Hello,

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).

An example

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).

Regards,

Raimund

• ###### Re: How can I calculate a max per period of maximums per day

Try a straight table chart with dimension Day and as expression

=rangemax( sum(Interval1), sum(Interval2), sum(Interval3) )

and to get the maximum across all days in a e.g. text box

=max( aggr( rangemax( sum(Interval1), sum(Interval2), sum(Interval3) ) , Day))

• ###### Re: How can I calculate a max per period of maximums per day

Many thanks for the formulas, both work fine!