Challenge #9: Analytics Ranking

[Animanga008]

Solution: https://youtu.be/9FwiR0kQwGQ

[DanRobinsonXbite]

Spoiler

Tried a few things here based on researching a few different solutions. Tile ended up being the one I used because it was completely new and in the end I had to take a look at another users use to get my head around it!

Sort by sount > Tile the count to add rank (leave unsorted) > Filter top 5 > Select and rename

[Salvatore_Miseo]

Hi everyone
below I am attaching my solution.

To solve the question I used three tools:

1)   Sort tool to sort the data in descending order;

2)   Formula Row tool to create the rank column  based on the following formula:

     IIF([count] != [Row-1:count], [Row-1:Rank] + 1 , [ROW-1:Rank] ) 

3)   Filter tool, to filter data based on rank

In my opinion, a specific tool should be created, to create classifications and rankings, perhaps with the possibility of considering multiple fields, or formulas
Especially for Top and Bottom (N) analysis

Hi everyone

[binu_acs]

Spoiler

[TheOC]

A nice an easy one!

Spoiler

A nice excuse to use the multirow formula to generate the ranking:

[jeremyhaber814]

Challenge #9

[Wamiru]

See attached my solution.

Will be happy for some feedback

[rcarog]

Solution attached.

[SadiyaGirach]

Completed

[Fynn]

so， I got two methods in my solution.

The first one needs more tools, the second one needs more RAM, I suggest the first one, it is easier and better than another.