Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am trying use Rank to get the rank for the User.
In the following data, if a user selected UserID = 2 then ranking based on Score;
I need to show 2 rows
- first for Study ID 1 with rank 2
- and second for Study ID 2 with rank 1.
How do I accomplish that?
User ID | First Name | Last Name | Study ID | Score |
1 | a | b | 1 | 4 |
2 | c | d | 1 | 2 |
3 | e | f | 1 | 1 |
1 | a | b | 2 | 2 |
2 | c | d | 2 | 4 |
3 | e | f | 2 | 2 |
Thanks
Maybe create a straight table chart with 1 dimension and 1 expression
Study ID | =Only(Aggr(Rank(Only({1}Score)), [Study ID], [User ID])) |
---|---|
1 | 2 |
2 | 1 |
Maybe create a straight table chart with 1 dimension and 1 expression
Study ID | =Only(Aggr(Rank(Only({1}Score)), [Study ID], [User ID])) |
---|---|
1 | 2 |
2 | 1 |
Thanks Stefan