Challenge #9: Analytics Ranking

[psk009]

#Solution 9: Tool used : Sort, Multirow, Filter

[Joppa]

This challenge is completed using a combination of Sort and Multi Row Formula.

[viniciusahanada]

I have two solutions, one using frequently used tools, and another relying on Tile tool.

[Angelica_Obi]

Solution

[vijaydholam]

Solved with multi row formula and filter tool

[Tanbir89S]

Solved! Solved! Solved!

Solved in two ways ---->>>>

Process 1 : Steps to be followed - 

• Sort Tool - Count as Descending
• Multi-Row Formula Tool 
  • Create New Field : Rank
  • Expression :  IF [count] = [Row-1:count] THEN [Row-1:Rank] ELSE ([Row-1:Rank]+1) ENDIF
• Filter Tool - Rank <=5

Process 2 : Steps to be followed - 

• Sort Tool - Count as Descending
• Tile Tool
  • Tile Method - Unique Value
  • Unique Column - Check count
• Filter Tool - Tile_Num <=5
• Select Tool - Select First, count and Tile_Num(Rename as Rank)

Yeah!! You've got the desired result. Congrats!

[wimbe3]

Solution below

Spoiler

[rchaidez]

Solved using the following tools: Sort, Multi-Row Formula and Filter

[VinodBestha_]

good one

[VinodBestha_]

good one