Help Calculating Rank

[erisman20]

Hello Everyone,

I have attached a qvf file for an example data set to this problem.

To summarize, I have a data model that includes a set of Questions, Teachers, Teacher's Students, and Student Scores for each question.

I want to create a table that displays a specific teacher's rank based on their students' average score for each question. 

Teacher 1 Rank Table:

Question Rank

q1	Teacher 1 Rank
q2	Teacher 1 Rank
q3	Teacher 1 Rank

Teacher will not be a field in the table, and each question will only show up once

Thanks!

Jordan

[dplr-rn]

Maybe i am over simplifying the problem.

is below what you want

[erisman20]

Not quite, I want a table that that only has the list of questions and a rank for a specific teacher. For example, the following table would be created for Teacher 1

Question Rank

q1	Teacher 1 Rank
q2	Teacher 1 Rank
q3	Teacher 1 Rank

[dplr-rn]

change the sort order and use a filter. (see below)
is the data accurate?

 

[erisman20]

No, teacher field should not be in the table and I only want one row per question.

[dplr-rn]

Ok. Your were not clear before
Try and Use firstsortedvalue

[sunny_talwar · Accepted solution]

Are you looking for this?

Expression

Only({<Teacher = {'t1'}>}Aggr(Rank(Sum(Score)), Question, Teacher))

[dplr-rn]

Assuming you want the top ranked teacher for each question. Use FirstSortedValue(Teacher,-Aggr(Sum(Score),Question,Teacher))