Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

FilipR
11 - Bolide

Solved.

 

Spoiler
FilipR_0-1664883569777.png

 

FilipR_1-1664883577778.png

 

GabrielaTudor
8 - Asteroid

Nice challenge!

 

Spoiler
Main Workflow:
GabrielaTudor_0-1664892573913.png



Macro:

GabrielaTudor_1-1664892609547.png

 



geoff_zath
Alteryx
Alteryx

I did this without a batch macro...not sure if it's needed here.

Spoiler

geoff_zath_1-1665773307304.png

Spoiler

geoff_zath_2-1665773334317.png

 

Kinga
8 - Asteroid

Hi,

 

Please find my solution below.

 

Spoiler
Kinga_0-1666253729079.png

Macro:

Kinga_1-1666253770493.png

 

 

Supergiant
8 - Asteroid
Spoiler
Supergiant_0-1666884450941.png

 

Supergiant_1-1666884471838.png

 

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid

It was quite easy to do without macro but have to admit that was diffcult for me to implemnet a batch macro. It is great that you forced me to go out from my comfort zone.

 

Spoiler
Sebastian_Chaieb2_0-1667396889697.png

Macro:

Sebastian_Chaieb2_1-1667396936139.png
and workflow without macro:
Sebastian_Chaieb2_2-1667396987978.png

AndrewHoData
8 - Asteroid

The biggest challenge was figuring out whether the Open column was referring to the act of opening an account or whether the account was still open.

 

I misunderstood the explanation initially as the denominator referencing the act of opening. When in fact the 'Open' column referred to the state of the account (whether an account is Open at the Start of Month). 


Spoiler

AndrewHoData_1-1667866163028.png

 

And the Batch macro:
AndrewHoData_2-1667866531766.png

 

NicolasSz
11 - Bolide

Nice one ! 

Linas
8 - Asteroid

Linas_0-1668695455750.png

 

martinding
13 - Pulsar

 

Spoiler

17.png

17a.png