community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

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
‎05-18-2019 08:35 PM

My solution

 

Spoiler
challenge 122 solution Eleonora Nazander.JPG
challenge_122_Solution Eleonora Nazander.yxmd
Reply
0 Likes
hanykowska
11 - Bolide
‎05-21-2019 03:18 PM
 
challenge_122_solution_hanykowska.yxmd
Reply
0 Likes
JWS
Alteryx Alumni (Retired)
‎06-20-2019 02:47 PM

Short and Sweet

challenge_122_solution_JS.yxmd
Reply
0 Likes
TonyA
Alteryx Alumni (Retired)
‎06-23-2019 02:28 PM

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
challenge_122_TonyA.yxmd
Reply
0 Likes
Johnny_Analytics
8 - Asteroid
‎07-02-2019 12:31 PM
Spoiler
Challenge_122.png
Reply
0 Likes
T_Willins
14 - Magnetar
14 - Magnetar
‎07-04-2019 07:30 PM

My solution.

Spoiler
Workflow 122.GIF

 

Reply
0 Likes
LisaD
8 - Asteroid
‎07-05-2019 08:53 AM
Spoiler
challenge122.PNG
challenge_122_LRD.yxmd
Reply
0 Likes
keng
8 - Asteroid
‎07-10-2019 12:33 PM

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

challenge_129_start_file KE.yxmd
Reply
0 Likes
alexo
8 - Asteroid
‎07-11-2019 08:10 AM

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

122.yxmd
Reply
0 Likes
hning003
7 - Meteor
‎07-19-2019 08:06 AM

Always fun to try to do it with fewer tools

challenge_122_start_file.yxmd
Reply
0 Likes