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

TimN
Pulsar

My solution.

lugesy
Asteroid
Spoiler
17_batch macro.png

 

ferg_smith
Asteroid
Spoiler
ferg_smith_0-1669313329241.png

 

brandon_bunney
Asteroid

🤔

Added a few tools that became obsolete as I solved through it. 

 

Spoiler
Screenshot 2022-12-15 110513.pngScreenshot 2022-12-14 165602.png
JoeChan619
Asteroid

The text is hard to understand...

Based on the question, I used my own way to calculate the open and close.

joshbennett
11 - Bolide
11 - Bolide

My solution:

 

Spoiler
Main workflow:
joshbennett_1-1671516378024.png

 



Batch macro:
joshbennett_0-1671516364925.png

 

FinnCharlton
Pulsar
Spoiler
FinnCharlton_0-1671707911724.pngFinnCharlton_1-1671707947349.png

 

 

gautiergodard
Pulsar
Spoiler
Solutions
danblythe
Asteroid
Spoiler
I enjoyed learning more about batch macros 😁