Challenge #9: Analytics Ranking

[MsBindy]

I also went the Multi-Row formula route.

[MarcusDoesBI]

Really enjoyed this one.

First time I ever used the Tile tool which gave me the initial 1-12 rank and after a bit of experimenting I finally figured out how to have multiple people in the same rank :)

[sagarb]

Used multi-row formula tool. But, good to know that "Tile" tool could be used.

[nick_ceneviva]

solution attached

[ADerbak]

For a "beginner" challenge - this one was more difficult for me than I anticipated.

Solution attached!

[PhilipMannering]

Satisfied with a 3 tool solution. Same as @Rachel_Burge. See a few using Tile tool. I must learn what that does..

Spoiler

[Elena_Caric]

My solution

[jamielaird]

Another fun challenge. Here's my solution:

Spoiler

1) Ordered by count descending.

2) Used a multi-row formula to create a new rank field that compares the current row count with the previous row count and either copies or increments the rank.

3) Added 1 to my rank scores as they initialised at 0.

4) Filtered the top 5.

[dheerajpoojari]

Solution attached