Challenge #9: Analytics Ranking

[jssandom]

My solution!

[mridenour]

Here's a slight modification to the formula in the Multi-Row Formula tool that handles ranking ties (this only works if you are not ranking within groups). E.g., instead of ranking: 1, 2, 3, 3, 4, 5, 6, 6, 7, this formula ranks it as: 1, 2, 3, 3, 5, 6, 7, 7, 9

IF [RecordID] = 1 THEN 1
ELSEIF [Row-1:Total Count]=[Total Count] THEN [Row-1:Rank]
ELSE [RecordID]
ENDIF

[nnilz]

Pay attention to the Multi-row formula. Solution attached

[nnilz]

Had to upload a much more efficient solution. Pay attention to the multi-row formula!

[tbayer]

Here's one way to do it! :)

[harrycooney]

Challenge 9 Solution:

[enci1017]

solution 9

[andreweckerson]

Solution: Challenge #9

[Samuel_To]

Hi,

This is my solution. 

Thanks and Regards,

Samuel