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

    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

      Voorbeeld max max.JPG

      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