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

robert-headington
8 - Asteroid

I didn't realize this was supposed to be a macro one and just solved it without one. But then I quickly did it with a batch macro

zkibz16
7 - Meteor

See attached for a Challenge #17 solution

rcarog
8 - Asteroid

Solution attached.

Toons
12 - Quasar

My solution with batch macro :

 

Spoiler
Toons_2-1615159959322.pngToons_1-1615159884625.png

 

 

AllexJia
8 - Asteroid

I didn't work out this challenge due to misunderstanding of the rules but learnt about  batch macro from the solution!Thanks.

Maskell_Rascal
13 - Pulsar

Here is my solution!

Spoiler
Workflow:
Maskell_Rascal_0-1618939137100.png

 

Macro:
Maskell_Rascal_1-1618939158724.png

 

Cheers!

Phil

KBL
7 - Meteor

Hi Everyone!

Nice one to get some basic hands on experience... 🙂 Solution attached!

Observations:

 - normally numerator is on top, denominator on the bottom however in the solution proposed is the other way around. My solution returns both.

 - according to the instruction, the reference date is a month ("For example, for June 2013,"), not necessarily 1st day of a month. May solution works any day of the input/reference month

 - in any case I think the original solution proposed is not quite correct. Here justification of my numbers returnedChallenge #017 explanation.PNG

RashedDS
8 - Asteroid

My solution

 

Spoiler
week17.JPG

 

Raphael_Ar
7 - Meteor
Spoiler
ara_rapha_0-1620284998579.png

 

Here is my solution.

ENix
8 - Asteroid
Spoiler

ENix_0-1620652947785.png

Spoiler

ENix_1-1620652974552.png