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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #9: Analytics Ranking

Asteroid

Nice, thank you

 

Spoiler
WeeklyChallenge9.PNG
Spoiler
 
 
Alteryx
Alteryx

As soon as I submit this answer I'm looking up a better way to do the ranking. I don't like my answer but it works.

Asteroid

The Tile tool! Thank you community, will be using that a lot now!

Meteor

I get to solve this with 4 tools. My approach is as follows:

 

- Sorted the Count Column in Descending Order.

- Used Tile tool with Unique Value method on Count Column

- Used Filter tool to filter Tile num <= 5

- Used Select tool to remove the unwanted column and changed the column name.

 

 
Asteroid

All done. 

 

Spoiler
Week9.PNG
Meteor

Solution Attached

Meteor

Great way to make use of the 'Tile' tool. 

 

Use the "Tile" tool to assign a new number for every unique value by selecting "Count", make sure "Leave Unsorted" is checked.

Spoiler
challenge_9_solution_BL.png
Alteryx Partner