# Issues of Ranks in Leaderboard **URL:** \ **Category:** Ask for Help\ **Created:** [January 23, 2023, 5:48am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012 "2023-01-23T05:48:41Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\ **Post date:** [January 23, 2023, 5:48am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/1 "2023-01-23T05:48:41Z")
Hello everyone, I wanted to display rank system, As you can see in the screenshot, after 1st rank it should be 2nd rank but it is showing 3rd rank, it is because I have used, find element index column, can anyone help to display sequential rank system. like 1,2,3 ![Screenshot 2023-01-23 111339-glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0ed47e7d610daee1df286ca46df0113469ad2bdb.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 23, 2023, 6:23am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/2 "2023-01-23T06:23:36Z")
> [@1st\_place\_medal2nd\_place\_medal3rd\_place\_medal Convert Number Score to Rankings in Glide!](https://community.glideapps.com/t/convert-number-score-to-rankings-in-glide/34103): > > Using a combination of new Glide Plugin Columns, you can now rank items based on a raw value (points, score, scale, etc.) [[Glide: Create a RANKED Leaderboard!] ](https://www.youtube.com/watch?v=QvNTzYx7tvI) ---
**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\ **Post date:** [January 23, 2023, 7:00am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/3 "2023-01-23T07:00:27Z")
@Darren_Murphy I followed this video itself, but I wanted to display the ranks sequentially, like, when 2 members have got 1st rank , the next person should have 2nd rank but it is 3rd rank in my case, could you please help me with that. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 23, 2023, 7:15am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/4 "2023-01-23T07:15:42Z")
~~So in your example, how would you decide who is 1st and who is 2nd?~~ Sorry, ignore that. I misread. Okay, so just so I’m clear… Imagine you have: - 1 person with 10 points - 100 people all with 9 points - 1 person with 8 points So the person with 8 points should be ranked 3rd, even though there are 101 others ahead of him? ---
**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\ **Post date:** [January 23, 2023, 7:22am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/5 "2023-01-23T07:22:18Z")
Yes, that’s how I want ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 23, 2023, 7:39am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/6 "2023-01-23T07:39:23Z")
Okay, so off the top of my head, this is what I would do: - Create a helper table and add enough rows to cover the maximum number of placings - Number the rows from 0 to N - Add a lookup column and target it add your Points column. This will give you an array of all the points scores. - Use the [Unique Elements](https://www.glideapps.com/plugins/uniq) plugin to create a second array from the lookup that contains only the unique points totals. - Sort the unique array using the [Array Sort](https://www.glideapps.com/plugins/sort-array) plugin - Now use a single value column that expands the sorted array into a list. Use From Start → Row Number. This will give you a list of unique points totals in a single column, from highest to lowest - To get the ranking position for each, use a math column that adds 1 to the row number - Now back in your Players table, create a single relation that matches their points total to the single value column in your helper table - And finally, use a lookup column to fetch each players ranking position via that relation. Edit: just thinking about it, you could if you wanted to, just add all those columns to your Players table. If row count is an issue, that might be a better approach. Up to you. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 23, 2023, 8:11am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/7 "2023-01-23T08:11:46Z")
@madhu - I just tested the above to make sure it works. It does, but you need an extra column to reverse the sort. Here is what it looks like in the data editor: ![Screen Shot 2023-01-23 at 4.09.59 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/6/06d795c003ca7530513d327740b0044201e49ada.jpeg) ---
**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\ **Post date:** [January 23, 2023, 9:08am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/8 "2023-01-23T09:08:09Z")
Thank you so much for your help, but i am stuck in the single value column, can you please tell me, what values you have used there. ---
**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\ **Post date:** [January 23, 2023, 9:29am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/9 "2023-01-23T09:29:36Z")
![Glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/7/97e17a290d10d11e24b726aab10052124971f88b.png) ![glide2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a70dedd0223421dc8e3c66cf6f7b82e5844f3800.png) Please check these columns. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [January 23, 2023, 9:29am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/10 "2023-01-23T09:29:53Z")
![Screen Shot 2023-01-23 at 5.27.28 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/d/fd2faf18300f6e6d9581f9ba02e02b96656823ba.png) - RowIndex is the column that contains Row Numbers, beginning at 0. In my example, I numbered them automatically, but you can also number them manually. - ReversedSort is the extra column I mentioned. It uses the Array Sort plugin to reverse the order of the sort. ---
**Author:** ![madhu](https://avatars.discourse-cdn.com/v4/letter/m/a8b319/32.png) [@madhu](https://community.glideapps.com/u/madhu)\ **Post date:** [January 23, 2023, 10:33am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/11 "2023-01-23T10:33:22Z")
Thank you so much for the help, it worked. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [January 24, 2023, 10:34am UTC](https://community.glideapps.com/t/issues-of-ranks-in-leaderboard/57012/12 "2023-01-24T10:34:21Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.