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

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
9 - Comet
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.

MattBenj
9 - Comet

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

andrewgu
Alteryx
Alteryx

Solution attached.

Maxine
8 - Asteroid

My solution to Challenge 17

jestinejoseph
8 - Asteroid

Struggling with Macros.

jestinejoseph_0-1638275542386.png

 

jestinejoseph_1-1638275587103.png