Challenge #9: Analytics Ranking

[MichaelStaig]

Better late than never

Spoiler

[mcarson1222]

Posting my first solution to a weekly challenge!

Spoiler

Spoiler:

I used the multi-row formula tool to accomplish this after sorting count desc. By checking 'Leave Unsorted' on the multi-row formula tool, the ranking was done on the descending order I had done previously rather than the default.

[lavanyadurai]

Spoiler

[mcultrera]

Similar to the posted solution except I utilized the unique tool instead of summary.

I also went ahead and created an alternate ranking where a proceeding tie doesn't bump you up.  (If there were two people tied for first then the third person is ranked 3 instead of 2). I did this by utilizing a record ID to bump it up against and take the max.

[kelsey_kincaid]

A nice quick one 🙂

Spoiler

[DavidW]

Spoiler

[Hitch]

Here's my attempt

[mpennington]

Solution attached.

Spoiler

[Kale_Malcom]

Spoiler

Based on the instructions I thought the result should actually be different in this challenge.  In a round of golf if there are 2 players tied for 1st the player with the next best score is then in 3rd.  I solved the ranking that way initially, but now have adjusted the multi-row formula to get the same result as the example.

[DataG8]

A few minutes longer than I would have liked it to take.

Spoiler