Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #9: Analytics Ranking

Angelxxl123
6 - Meteoroid
 
Angelxxl123
6 - Meteoroid
 
SHEZ2161
5 - Atom

This is the second is the second challenge I have done. First i sorted the names and ranks in descending order. Then I created an if statement to see if the score above was the same as the current. If the score above is the same as the one below then it gives the same rank. If the score isn't the same then it pluses one to the rank

Spoiler
Capture.PNG 

 

Angelxxl123
6 - Meteoroid
Good job, much better than my solution!!
garrettlem1017
8 - Asteroid

Used multi row formula to solve this challenge ... Tile could be used as well.

Angelxxl123
6 - Meteoroid
Thank you for your procedure, very useful! better than my solution !
Ellie_P
8 - Asteroid
 
Niklas
8 - Asteroid

🙂

mikecusic
Alteryx Community Team
Alteryx Community Team

Summarize, sample, sort, text to columns 🙂

Steph3388
7 - Meteor

Done!

clipboard_image_0.png