Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try this?
=sum(aggr(count (DISTINCT {$<[StudentId]={"=[Status_Value]= { '1-Junior', '2- Sophomore'} " } >} if ($(vrDateRange), [StudentId]) ),[Course Number], [ResultEnd Date]))
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]))
Tried. Returns 0
First expression does not return correct value. 2nd expression returns 0
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]))
May be remove "=" and then check
or else use Match function to retrieve the same
Match(Dim,'Value1','Value2')