Count issue

[#1]

I am looking to count the total number of ID where ADM = YES and each ID has a start date SD. Have a calendar setup. Ideally Example: when the year = 2011 , Month = August and Day = 08 is selected the result should be 2. Set analysis to be used?

  ID                        SD

f5464                01/08/2011

w4578               04/05/2006

q4579               01/08/2011

r4565                04/07/2006

k4546               06/05/2009

q5657               15/01/2006

g4576                14/03/2001

Regards,

Koushik.

[#2]

Hi,

You can aggr().

AGGR(COUNT(ID),SD))

[Gysbert_Wassenaar]

count({<ADM={'YES'},SD={'*'}>} distinct ID) will count all distinct ID's where ADM = YES and SD is not null.

[#4]

Have a field ARRIVAL_DATE which controls the calendar in addition to the above data. Ideally I am looking to match ARRIVAL_DATE to SD and count the number of ID where ADM = YES.