Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

Inactive User
Not applicable

I like it! 

rohanonline
10 - Fireball

Here's my solution

CKP
10 - Fireball

My solution

 

Spoiler
challenge_9_mysolution.jpg
Himanshu_1984
8 - Asteroid

please find my solution below

Himanshu_1984
8 - Asteroid

Little modification added two possible solution

HCowley
6 - Meteoroid

Success!

Gopinaath
8 - Asteroid

Here is my solution:

Spoiler:

Spoiler
Gopinaath_0-1583555772876.png

 

Gopinaath
8 - Asteroid

Spoiler:

Spoiler
That's interesting. I wonder whether there would be any test cases where not having a condition for the starting rank would throw an error. I performed the sort at the beginning and then inserted a record ID tool. That way, I could use a separate condition in my formula for the first record. I wanted to make sure the first record was ranked 1st. 
LopamudraPradhan
7 - Meteor
Spoiler
LopamudraPradhan_0-1583591182500.png

 

 

 

 

 

JanetteJohnston
7 - Meteor

mine