Aggregation and Set anaylsis question

[#1]

The requirement is

Count the students who took the exam before Jan 15, 2015 and populate a grid as shown at the bottom of the image. How can I do this double aggregation like

Aggr(Max(Exam Taken Date),Student Name) and then count for exam dimension. The Student Name dimension will

not show in the final grid. See below the last grid in the image. Please help

[sinanozdemir]

Or you can try to handle NULL values in the load script which I personally think is less confusing:

I tried to mimic your dataset above:

There are two records with NULL values

And then in the load script, I put the below:

Now, set analysis is cleaner than before and less confusing, I think:

Let me know if this helps.

[Anonymous]

how about count(if(isnull (Max_Of_Activity_Date),Project_Lead_GUID))

if Project_Lead_GUID has duplicate records, use distinct, so that wud be:

count(distinct(if(isnull (Max_Of_Activity_Date),Project_Lead_GUID)))