1 Reply Latest reply: Sep 10, 2009 4:01 PM by banciu RSS

    How can I see the date when the maximum number of events happened?

    banciu

      I have the following set of data:

      Event Responsible Date Hour

      1 X 5 Aug 2009 10.22

      2 X 5 Aug 2009 10.40

      3 Y 5 Aug 2009 12.33

       

      4 X 6 Aug 2009 12.27

      5 X 6 Aug 2009 15.40

      6 X 6 Aug 2009 16.30

      7 Y 6 Aug 2009 16.38

      8 Y 6 Aug 2009 17.38

       

      9 X 7 Aug 2009 15.27

      10 Z 7 Aug 2009 14.40

       

      First, I want to find out what was the day with the maximum number of events for person "X" (I will put it in a text box):

      max(aggr(count({1<Responsible= {'X'} >} Event), Data))

      The answer is 3, which is a good answer.

      I want to find out now what was the date when this happened (the maximum number of events for person X). How do I do it? Does anyone have an idea?

      Thank you.

      Banciu