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