Set analysis aggregation for a field with multiple values

[#1]

Hi,

I have the following set analysis that works to give student course completion for students having Status_value as 1-Junior

=sum(aggr(count (DISTINCT {$<[StudentId]={"=[Status_Value]='1-Junior'" } >} if ($(vrDateRange), [StudentId]) ),[Course Number], [ResultEnd Date]))

I want to modify the above expression to give me a total count of student course completion across all Status_values. I tried the following but got 0 as result.

=sum(aggr(count (DISTINCT {$<[StudentId]={"=[Status_Value]='1-Junior', '2- Sophomore'" } >} if ($(vrDateRange), [StudentId]) ),[Course Number], [ResultEnd Date]))

Kindly suggest!

[vishsaggi]

Try this?

=sum(aggr(count (DISTINCT {$<[StudentId]={"=[Status_Value]= { '1-Junior', '2- Sophomore'} " } >} if ($(vrDateRange), [StudentId]) ),[Course Number], [ResultEnd Date]))

[Anil_Babu_Samineni]

May be try this

=sum(aggr(count (DISTINCT {$<[StudentId] = , [Status_Value] = {'1-Junior', '2- Sophomore'} >} if ($(vrDateRange), [StudentId]) ),[Course Number], [ResultEnd Date]))

Or

=sum(aggr(count (DISTINCT {$<[StudentId]={"=[Status_Value]={'1-Junior', '2- Sophomore'}" } >} if ($(vrDateRange), [StudentId]) ),[Course Number], [ResultEnd Date]))

[#4]

Tried. Returns 0

[#5]

First expression does not return correct value. 2nd expression returns 0

[sunny_talwar]

May be this:

=Sum(Aggr(Count (DISTINCT {$<[StudentId] = {"=Match([Status_Value], '1-Junior', '2- Sophomore')"}>} if ($(vrDateRange), [StudentId])), [Course Number], [ResultEnd Date]))

or this

=Sum(Aggr(Count (DISTINCT {$<[Status_Value] =  {'1-Junior', '2- Sophomore'}>} if ($(vrDateRange), [StudentId])), [Course Number], [ResultEnd Date]))

[Anil_Babu_Samineni]

May be remove "=" and then check

or else use Match function to retrieve the same

Match(Dim,'Value1','Value2')