Challenge #9: Analytics Ranking

[Kusk]

Challenge Completed

[crukesh]

if [count] != [Row-1:count] then [Row-1:Rank] + 1 else [ROW-1:Rank] endif

[Peter_Delmer]

My solution.  Took me three steps.

[AngelPradeesh]

The below tools will give you the desired output:

1. Use Sort tool to get count in descending order

2. Use a Multi-Row tool and use the formula if [count]!=[Row-1:count]
then [Row-1:Rank]+1
else [Row-1:Rank]
endif

Name the new field Rank

3. Use the filter to get Rank<6 

Thank you!

[jennifer_owens]

Below is my solution. 

[Timi8]

My solution

[Vanousheh]

My first challenge solved :)

[HardikJani]

Hi, I took a longer approach to reach a solution. I multiplied all the count values to get negative values then used the tile tool to get a unique value for each negative value. Since I had all negative values "-17" got ranked tiled as 1 and so on. Lastly, I used the select tool to get rid of unwanted columns and change the data types. I was surprised to see that I took an extra step and could have done it in just 3 steps. Great learning.

[tbennett013]

My solution for Challenge #9

[Inactive User]

Done