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

Eleonora
8 - Asteroid

My solution

 

Spoiler
challenge 122 solution Eleonora Nazander.JPG
hanykowska
11 - Bolide
 
JWS
Alteryx Alumni (Retired)

Short and Sweet

TonyA
Alteryx Alumni (Retired)

This one went pretty quickly. The actual ranking only needed two tools. I added a bit to generalize the solution in case the items didn't come in sorted.

Spoiler
challenge_122_TonyA.png
Johnny_Analytics
8 - Asteroid
Spoiler
Challenge_122.png
T_Willins
14 - Magnetar
14 - Magnetar

My solution.

Spoiler
Workflow 122.GIF

 

LisaD
8 - Asteroid
Spoiler
challenge122.PNG
kennetheng
8 - Asteroid

I used Record ID and then a multirow formula. Ended up with the same results! 

alexo
8 - Asteroid

Nice use of a multi row formula tool, along with a record ID to get the number of rows up until that point.

hning003
7 - Meteor

Always fun to try to do it with fewer tools