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

sri1917
5 - Atom

Tried my first alteryx challenge today ..discovered tile tool thanks to 

kevin025
8 - Asteroid

Here is my 2 solutions.

 

 

Spoiler

Solution #1 is very short and inspired by @mceleavey that involved the use of Tiles Tool

 

Solution #2 is more logical. I basically used Summarize to group up the count, sort it and filter out top 5, then I used join to rank it.

 

challenge#9.png

 

 

josh_ebg
6 - Meteoroid

My solution. Thanks!

bmcclelland46
10 - Fireball

My solution - liked the way I presented a little better but the text to rows tool makes it match the output.

 

Spoiler

bmcclelland46_0-1596597591325.png

 

yunpeng
8 - Asteroid

Multi-row formula tool comes in really handy for this challenge

 

Spoiler
yunpeng_0-1596618317872.png

 

HFW
6 - Meteoroid

Solution submission.

mollymargolis
8 - Asteroid

My solution for this challenge

bhanu5
7 - Meteor

It worked for me.

DJYS
5 - Atom
Spoiler
Did a multi-row formula approach.
ChrisBailey
7 - Meteor

Done!