community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #9: Analytics Ranking

Asteroid
Spoiler
9. Analytics Ranking.PNG
Meteoroid
Spoiler
Went with a Sort to Formula to Multi-Row Formula to Filter tool. Might be clunky but it works.

Solution attached.

Meteoroid
 
Moderator
Moderator

Here is my solution

Community Moderator
Asteroid

solution attached

Meteoroid

Thank you for the challenge. 

Spoiler
9 Fei's Attempt.PNG
Meteoroid
Spoiler
RC_Challenge9_Solution.png
Highlighted
Meteoroid
Spoiler
Sort ascending by count, rank over count, filter for top 5 ranks and rename columns.

challenge 9.png
Asteroid

Learned how to use a new tool!

Inactive User
Not applicable

Hi guys,

 

Attached is my solution.

 

Best Regards,

José Andrés.