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

meeravijayan2011
8 - Asteroid
Spoiler
Spoiler
122 solution.png
mbogusz
9 - Comet

Took the join and summarize route (don't try this at home) vs. recordID and multi-row formula route (simply the best).

 

Spoiler
2019-10-04 10_44_19-Greenshot.png
arjanloogman
8 - Asteroid

Quick one... did not use the recordID route, but just another multi-row-formula...

 

Spoiler
Screenshot 2019-10-08 at 16.53.22.png

Hav a nice day!!

ddiesel
13 - Pulsar
13 - Pulsar

My solution:

 

Spoiler
Capture.JPG
I got so excited about the Multi-Row formula tool, that I used it instead of Record ID at the start. Had it solved in under two minutes, but then felt a little silly when I saw the "standard answer" starting with RecordID.
JA
6 - Meteoroid
Spoiler
Alteryx_Weekly_Challenge_122.png
Inactive User
Not applicable
 
T_Willins
14 - Magnetar
14 - Magnetar

Reposting to add attachment.

 

Spoiler
Workflow 122.GIF

 

justindavis
10 - Fireball
Spoiler
challenge_122_solution_justindavis.PNG

Two minutes... curious what leads to this one being classified as intermediate versus beginner? Is it the tools that are most likely to be used?

Xlblaze
7 - Meteor
Spoiler
My Solution

Xlblaze_1-1572428776568.pngXlblaze_0-1572428743313.png

 Also a little confused as to how this is intermediate rather than beginner.

ImranA
8 - Asteroid
Spoiler
ImranA_0-1572428923259.png

First posted completed Challenge, we did a mini grand prix and I did it differently to my colleague/tutor! He was a little quicker though 😞