Challenge #17: Month-over-Month Retention Rate

[apathetichell]

The dataset feels kind of puny -this would definitely be a more fulfilling challenge if there were tons of entries. and maybe more data prep...

[balajilolla]

Spoiler

Solution Attached

[sara_burk]

[MichelleL]

Great practice, thank you!

[JasonHu]

Spoiler

Here is my submission.

[hoadinh]

My solution:

[dhavaldoshi]

How to do it as a beginner?

• Do not fret to over use filters/tools when you are learning, especially with AND logic, infact it is more efficient that way!

Think of it as filtering a 100 rows on 3 conditions at once

OR

100 with one condition, 30 with another, 10 with third

The second one is always better

• Batch Macro: Always helps repeat tasks if you want to do it for a group. In this case start of month, please understand this is the difference between a standard a batch macro.

Spoiler

[ExploreMore]

Spoiler

 

[DanTh]

Spoiler

This took me quite a while to puzzle through. I decided the best approach was for me to make a single workflow that worked for one month, then I started putting the Batch Macro together to iterate through the other months. I had an error which was showing I was passing a Date field through my numerical Months filter, so had to do some digging to find the right parameter in the Macro block.

4/5

[mnmemilymnm]

My solution