Forum Discussion
RANKX showing duplicated values
- 8 years ago
tex628 Thanks for all the help i already found a way to show the information i wanted so instead of using my SchoolName i used the ClassID and now its showing the results i wanted .
As my ClassID they have schools names abbreviated as for examples PORGpsi1619 , i made table with the abreviattions and the school names so in the meetups people can understand what the 3 first letters means
Try this:
Go into filtersChosoe Top N instead of basicWrite 5 in top and then by value "ModuloAtraso"
tex628 Hey i tried your method but it doens't filter top 5 neither gives me only top 5 as i would like as this :
School ClassName MódulosAtraso Rank
Porto Class1 900 1
Viseu Class1 760 2
Viseu Class90 750 3
Porto Class20 600 4
Porto Class19 550 5
- tex6288 years ago
Community Champion
Sorry i was away at lunch.
I think theres something im missing or missunderstanding, do you think you could provide a picture of your visuals?
/ J- rui_silva8 years ago
Helper I
tex628 Thanks for all the help i already found a way to show the information i wanted so instead of using my SchoolName i used the ClassID and now its showing the results i wanted .
As my ClassID they have schools names abbreviated as for examples PORGpsi1619 , i made table with the abreviattions and the school names so in the meetups people can understand what the 3 first letters means
- tex6288 years ago
Community Champion
Alright! Glad it worked out!
/ J