Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
You can aggr().
AGGR(COUNT(ID),SD))
count({<ADM={'YES'},SD={'*'}>} distinct ID) will count all distinct ID's where ADM = YES and SD is not null.
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.