community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #122: Think Like a CSE...Ranking Data

Alteryx Partner
Spoiler
Spoiler
122 solution.png
Asteroid

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
Alteryx Partner

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!!

Quasar

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.
Alteryx Partner
Spoiler
Alteryx_Weekly_Challenge_122.png
Asteroid
 
Bolide

Reposting to add attachment.

 

Spoiler
Workflow 122.GIF

 

Asteroid
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?

Meteor
Spoiler
My Solution

Xlblaze_1-1572428776568.pngXlblaze_0-1572428743313.png

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

Atom
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