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

JTCairns
8 - Asteroid

Done!

BreShawna
5 - Atom

Another one down! It was a little tricky to get those with the same count to have the same rank. I ended up having to peek at some of the solutions other people had posted.^_^

DavidJShi311
6 - Meteoroid

I initially did a descending sort before the summarize (to group the rows with the same count).. which created a simple error in that the summarize grouping function will automatically resort the list in ascending or descending.  While it will probably work to put in second sort function after the summarize, it is much easier to put the summarize function first before the sorting function. 

puneet707
6 - Meteoroid

My Solutions- Adding two solutions

 

Simonvm9114
8 - Asteroid

Here's my solution, a bit different from the actual solution, but it works and quite clean I'd say.

rajvikash
5 - Atom
 
DaisyJones
8 - Asteroid
Spoiler
Challenge 9 img.jpg

Here is my solution.

danielmiranda
5 - Atom
 
NikitaParab
8 - Asteroid
Spoiler
alteryxWeekly9.jpg

Here is my solution. Used a formula to rank count using the Multirow tool in Alteryx

BenMoss
ACE Emeritus
ACE Emeritus
Spoiler
Multi-row FTW

This was nice and quick!