We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #17: Month-over-Month Retention Rate

AlexBough
7 - Meteor

Got there eventually! 

 

jonathanwillis
8 - Asteroid

Here's my workflow 

binay2448
11 - Bolide

Done without Macro...

AlexvanOs
8 - Asteroid

Again, no macro needed to produced the data, but since it was required in the challenge...

Spoiler
For these 4 months not an issue to fill the months by hand, but to make it scalable, I chose to use a start date and an end date. Then, I generate the rows in between and connect that output to my macro. My flow top left, the macro in the red square bottom right

Challenge 17 solution.png

I might post the non-macro version later, if I'm up for that challlenge. 😉

PatForData
8 - Asteroid

I've got a lot more work to do with Batch Macros

Spoiler
PatForData_0-1635176428991.png

 

LiuZhang
8 - Asteroid
Spoiler
17 - 2.png17.png

The closed account caught me out a bit, took a while to figure how to deal them within the macro.

MichMatt
8 - Asteroid

I understood the batch macro fundamentals but had a hard time understanding the date requirements.

andrewgu
Alteryx
Alteryx

Solution attached.