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

michael_heitz
8 - Asteroid

I used a mulit-row tool to make it easy, but a challenge as I am not well versed in that tool!

mbonora
7 - Meteor

My solution.

Sajeel_Kershi
8 - Asteroid

Sorted count descending then used the multi row tool to increase rank by 1 whenever the count changed and then filtered out rank < 6 to get output

T_Willins
14 - Magnetar
14 - Magnetar

Free time on New Years Eve, so time to clear some old challenges!

johnemery
11 - Bolide

My solution matches what others have posted. Being brand new to Alteryx I don't have the product knowledge to be able to really think creatively yet, so basic, straight-forward solutions are required.

 

 

DavidThorpe
Alteryx
Alteryx

Tried a few ways of doing this:

 

Spoiler
Initially used multi-row formula, but instead switched to tile tool - remember to check leave unsorted!
Tom_Luthi
8 - Asteroid

Solution attached.

Shivam
8 - Asteroid
Spoiler
Spoiler Sol9.JPG
pmyung87
5 - Atom

My solution

KeithTroutt
8 - Asteroid

My solution