Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.