Free Trial

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

paul_houghton
12 - Quasar

Rocking through some more history

 

Spoiler
Challenge 17 macro.jpg
robbinrv
8 - Asteroid

Bit of a headache afterwards, but all done! good practice for real client problems.

 

Spoiler
Alt_Chal_17_2.PNGAlt_Chal_17_1.PNG

 

 

OllieClarke
15 - Aurora
15 - Aurora

My first Batch Macro :)

 

Spoiler
Challenge 17-1.PNGChallenge 17 - 2.PNG
akuma162
6 - Meteoroid

My Solution to this challenge

jevon
8 - Asteroid
Spoiler
challenge17 - 2 pic.pngchallenge17pic.png

I liked this one ;)

jxuan
7 - Meteor

#17 Solution

bdaniels
8 - Asteroid
 
arein0
8 - Asteroid
 
CaraI
Alteryx
Alteryx

I originally put the date parsing in the macro, but then decided to pull them out just in case the date formats changed.  Turns out that move matched many of the solutions directly.  The calculations around open and closed took some experimenting and validation to get right.

 

Spoiler
Spoiler 17 Macro.jpg17 Workflow.jpg

 

kcoulon
8 - Asteroid

Challenge solved - was on the right track but just need a little help from the solution file!  Thanks for more batch macro practice!