We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #9: Analytics Ranking

SamarthSupekar
6 - Meteoroid

Uploading the solution. It's quite straight forward but has a little manual part. Not recommended for large dataset. 

mattbov92
8 - Asteroid

My Solution

christopher_ontkean
8 - Asteroid

Solution

akuma38
7 - Meteor

My solution

rushikesh_patil
7 - Meteor

Solution is attached.

CStiffler
6 - Meteoroid
Spoiler
Finish.JPG
mwong
8 - Asteroid

Uploading old solutions I have lying around

MDestra
8 - Asteroid
 

#9 results:

Updated to show 2 options. 

IF statement in option 1: 

IF [Row-1:count]=[count] THEN [Row-1:RANK]
ELSEIF [Row-1:count] > [count] THEN [Row-1:RANK] +1
ELSE 1
ENDIF

 

challenge_9_start_file - MD.PNG

jpg34
8 - Asteroid

my solution and an alternative I found online

orangebomber
7 - Meteor

Spoiler