Challenge #9: Analytics Ranking

[KimishaP]

great challenge

[IraWatt]

Great Challenge!

Spoiler

[ShankerV]

Here is my solution

Used Multi-row formula to achieve it.

[ShankerV]

Explaining how I achieved in 2 steps

Step 1. Use the Multi-row Formula tool

Create New Field - Rank

Num rows - 1

Expression

if([count]=[Row-1:count])

then [Row-1:Rank]

else [Row-1:Rank]+1

endif

Step 2: Use Filter to sort only up to Rank 5

Result is achieved

[grotunno]

solution

[elaineyuan]

I'm out of Alteryx shape. 😅

Spoiler

[jamesbarker]

Nice easy challenge 👍

[NathalieHP]

Great introduction to the Tile tool :)

[Billy_Jones]

Spoiler

[Tofel]

Spoiler