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 #9: Analytics Ranking

Inactive User
Not applicable

This one was fun, I found a really straight forward solution (multi-row to the rescue!)

AntoineR1509
7 - Meteor

Here is my solution

kennetheng
8 - Asteroid

Instead of using the summarize tool, I used the unique tool, but otherwise arrived at the same answer! 

CK3
5 - Atom

Just learning, but I finally got there

CK3
5 - Atom

Just need to filter out the Ranks > 5 to match the output

EFran
7 - Meteor
Spoiler
9.png
 
piotrzawistowski
8 - Asteroid

My solution.

Pete

gguedes1
8 - Asteroid

Hi Alteryx Universe,

 

Please the attached solution for Challenge 9. 

 

 

Challenge9.PNG

gustin33
7 - Meteor

Tried figuring out a multi line formula and could not do it that way so stuck with a longer workflow.