Challenge #9: Analytics Ranking

[Sylvana]

Quick and easy 🙂

[VenkateshJeyaraj]

The trick is to use ''Multi-Row Formula" with the following formula:

iif([count]==[Row-1:count],[Row-1:Rank],[Row-1:Rank]+1)

Bien a vous,

Venkatesh

[Lucatelli]

Please find attached my proposed solution.

[Varshaa]

My approach as follows. Ran in 1.4 seconds.

[cody_rush]

Spoiler

[FredNajjar]

Spoiler

[SeanAdams]

redone this challenge with a dual Alteryx / Python solution.    Lovely easy challenge to build confidence

Spoiler

#SnakingMyWayThruChallenges

[Chiaroscuro]

HI! I'm here to share my solution.

Unlike the given solution for this challenge, my solution is just simple.

Please see my solution below:

Spoiler

Have a nice day! 🙂

[jarrod]

Spoiler

Solving through Alteryx and Python

#SnakingMyWayThruChallenges

[mulvihi11]

Spoiler

Short and sweet thanks to Multi-Row Formula tool.