ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start 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

Reesetrain2
9 - Comet
9 - Comet

All,

 

My solutuion after many a trial-and-error!

-Cheers!

Spoiler
Capture.PNG
Alekh
9 - Comet

 

Spoiler
17..png

 

David-Carnes
12 - Quasar

Pretty straightforward.  The only "oh, duh" moment came when I realized I had left out part of the equation to enumerate the accounts open at each month.  I had thought it through when examining the data but spaced on it during the actual crafting of the macro.

 

Spoiler
017.png

batch_107.png
ADerbak
11 - Bolide

Solution Attached!

Niklas
8 - Asteroid

Wanted to try without the macro, the solution for tracking previous cancellation isn't as scalable / resilient as I'd like, but it works. 

Eleonora
8 - Asteroid

My solution

 

 

Spoiler
challenge 17 solution Eleonora Nazander.JPG
FRANCK_ROUQUETTE
8 - Asteroid
Thank You for the exercise - please find attached my proposed solution.
Vidya26
8 - Asteroid

My Solution!!

Tom_Luthi
8 - Asteroid

solution attached.

ConradW
8 - Asteroid

17-complete