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 #122: Think Like a CSE...Ranking Data

JoachimCaronTIL
8 - Asteroid

Here is my solution.

Spoiler
I thought this challenge was about Join Multiple and Make Groups Tools... But apparently it is not :D
bobd
8 - Asteroid

my solution

FinnCharlton
13 - Pulsar
Spoiler
FinnCharlton_0-1670604557426.png

 

junjie_lei
7 - Meteor

Think Like a CSE...Ranking Data

es7h3r
7 - Meteor
Spoiler
challenge 122.png
zcahsyl
7 - Meteor

done

Vio
6 - Meteoroid

:)

JBevan89
5 - Atom

My Solution is attached.

 

In Excel there is a Rank function which would do this quicker.  Is there not a similar Rank function in Alteryx?

 

I like this Multi-Row function and can see it's uses.  But if there is a similar Rank function to Excel, then I would prefer to use this.

BS_THE_ANALYST
14 - Magnetar

nice

Spoiler
BS_THE_ANALYST_0-1674497235864.png

 

ALexAn
8 - Asteroid

My solution seemed simple.

Took a bit to understand the proposed solution logic, in order to find a situation where the easier one might fail.