Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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))
Many thanks for the formulas, both work fine!