Trying to find a way to RANK in the GLIDE data editor. Anyways of doing this with the newly released data columns. Cheers

Just follow this: [image] 1st_place_medal2nd_place_medal3rd_place_medal Convert Number Score to Rankings in Glide! Community Resources Using a combination of new Glide Plugin Columns, you can now rank items based on a raw value (points, score, scale, etc.) [Glide:…

Hi, jason :slight_smile: How about elaborating 1st what outcome you are expecting, like The min max Rank and how they look like (icons, colors, numbers, stars, alpha, number, etc.), how many in all max you expect to show at once to anticipate on the layout. What are the items you wish to rank fro…

Thanks, L.M. I’m putting together a leader board that ranks Point. This is achievable in sheets but I am stuck on how to achieve this in the data editor. [Screenshot (51)]

[image] 1st_place_medal2nd_place_medal3rd_place_medal Convert Number Score to Rankings in Glide! Community Resources 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 L…

Awesome Jeff. I’ve got that working but with one snag. The placings skip from 1st to 3rd. I understand the points are tied at the moment, this was intentional to see how this situation would display. The guys with 98 points are correctly ranked as 1st but the guys with 96 points are displayed as 3r…

I’d be curious to see @Robert_Petitto ’s response to this since he put together the tutorial. I haven’t put it into practice myself, so I’d have to analyze his method in detail to give a good answer. Are you saying that 2nd place is skipped and the tie is giving you 3rd and 4th rankings, or do you …

Hm. So you have two tied for 1st and the next person shows as 3rd because their point value is located in the third “slot” in the array. Might need to remove all duplicates in the original array before determining the array position.

[image] Robert_Petitto: Might need to remove all duplicates in the original array This worked!

This has worked a treat. Jeff shared earlier. Things seem to be coming together. My next issue is performing the ranking whilst separating my user’s into three distinct categories. Open/ Competitive/ Elite.

RANK VIA New data columns

Ask for Help

Robert_Petitto November 7, 2021, 11:51pm 8

This worked!

🥇🥈🥉 Convert Number Score to Rankings in Glide!

Topic		Replies	Views
🥇🥈🥉 Convert Number Score to Rankings in Glide! Community Resources tutorial	31	3982	January 3, 2024
Issues of Ranks in Leaderboard Ask for Help	10	971	January 23, 2023
How to Rank High to Low numbers from 1st to 10th etc Ask for Help	3	686	April 4, 2022
Ranking dentro do aplicativo Ask for Help	5	225	January 1, 2024
Show ranking of items in description Ask for Help	4	197	December 12, 2023

RANK VIA New data columns

Related topics