Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

jusdespommes
8 - Asteroid

Nice, thank you 🙂

 

Spoiler
WeeklyChallenge9.PNG
AbbieRoss-Carter
8 - Asteroid
Spoiler
 
kmbutterfield
7 - Meteor
 
DuncanT
Alteryx Alumni (Retired)

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.

Si-Pri
8 - Asteroid

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

jaiswas1
7 - 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.

 

 
timrains
8 - Asteroid

All done. 

 

Spoiler
Week9.PNG
Assaf_m
11 - Bolide

Solution Attached 🙂

Billigans
8 - Asteroid

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
kmcdaniel
8 - Asteroid