Challenge #9: Analytics Ranking

[dzeyer]

my solution

[chandler-gjino]

attaching my solution

[VipulThakur]

Solve this Challange with 3 Tool:

1. Short 

2. Multi-Row Formula 

3. Filter

1. Short: Arrange Count in Descending 

2. Multi - Row Formula: Create new field "Rank" 

If [Count] != [Row-1: Count] then [Row-1:Rank] + 1 else [Row-1: Rank]endif 

3. Filter: Rank<= 5

[Towers]

simple one

Spoiler

[AImbody]

Spoiler

[MitchellBliesner]

I am working my way through the Alteryx Challenges as I am learning Alteryx. Here is my solution to the problem.

[krishnakumare]

I have solved this using Sort, Multi Row Formula and Filter tools. Please see attached

[kaitlinDS37]

Spoiler

[DirkN]

Here is my solution. I guess it is the same as many had before me.

[Cshoben]

Here is my solution. I'm sure there is a less convoluted way. Uploading before viewing the provided solution.