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 #17: Month-over-Month Retention Rate

AngelosPachis
16 - Nebula

Challenge #17 solved

 

Workflow:

 

Annotation 2020-08-01 203240.png

 Batch Macro:

 

Spoiler
Annotation 2020-08-01 203206.png
mollymargolis
8 - Asteroid

My solution

Per
11 - Bolide

Did not understand exactly what I had to calculate based on description. Had to open the solution to understand the intention 🙂

JethroChen
10 - Fireball
Spoiler
challenge_17_jc.PNG
phottovy
13 - Pulsar
13 - Pulsar

I found this much easier to do without a macro. It wouldn't be very efficient with a larger data set but still seems more straightforward. I'm sure there is something I'm not accounting for in a real world scenario.

 

Spoiler
17.PNG
LHolmes
9 - Comet

Good practice for macros. 

 

Spoiler
017 - Solution.PNG
JoePC
9 - Comet

Solution Attached

myouree
8 - Asteroid

Solution attached.

HarrisonHolt
7 - Meteor

wc 17 

simbert
8 - Asteroid

Just realised I never posted my solution to this challenge!