Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
If anyone can help me, thank you in advance
I have a list of students who have expressed wishes (school choice)
I need to calculate the following indicators (by school):
- Number of students rated school (value of the dimension) -> OK
- Number of students rated school in addition to a School "Y" (variable) -> OK
- Number of students who ranked the best school that the school Y -> I need help on this expression
See attached file
Thanks,
Best regards,
D.Sadki
I found the solution
Count(distinct if(aggr(only({1}Wish)-Only({<Y_School_Wish.SchoolKey={"$(vSelectSchool)"}>}Y_Wish),SchoolKey,StudentKey)<0,StudentKey))
Thanks
I think this expression should do the trick:
I haven't tested it properly against your data - so I will do that and come back to you unless you verify first and confirm...
Hi,
I'm sorry but this is not working
Best regards,
D.Sadki
>>Number of students who ranked the best school that the school Y
This is not clear which is best - the first school or school Y?
Hi,
sorry I misspoke,
The best school is the one that has a lower wish...
Exemple :
StudentKey SchoolKey Wish
146 213 1
146 82 2
146 209 3
146 609 4
146 208 5
146 206 6
146 126 7
146 196 8
146 212 9
146 92 10
146 227 11
SchoolKey Y = 92
Number of student who ranked = 1 ( 9 Wish before the school 92) and so on
I want to count all the student that satisfied this condition in a st table with only School as dimension
Thanks
Best regards,
D.Sadki
I found the solution
Count(distinct if(aggr(only({1}Wish)-Only({<Y_School_Wish.SchoolKey={"$(vSelectSchool)"}>}Y_Wish),SchoolKey,StudentKey)<0,StudentKey))
Thanks