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

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

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

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

I wonder if my question has an answer or not.

Theoretically, it should be something like :

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

but obviously this doesn't work.