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

Stevej028
7 - Meteor
Spoiler
image.pngimage.png
Nicholas_Bignell
8 - Asteroid

Still don't really understand how macros work, but did got it working in the end more by luck.

JamesCameron
8 - Asteroid

My effort

 

Spoiler
Flow

JamesCameron_0-1574070051632.png


Macro

JamesCameron_1-1574070093517.png



mheinze
Alteryx Alumni (Retired)

good refresher on batch macros. 

moritzsturm
7 - Meteor

Solution attached.

Laszlo_D
8 - Asteroid

My Workflow: 

image.png

And the macro:

 

Laszlo_D_0-1576797144574.png

AV8
8 - Asteroid
Spoiler
SpoilerWorkflow.JPG
Spoiler
MacroMacro.JPG

Wasted a lot of time , due to wrong logic in formula tool.

rmassambane
11 - Bolide
 
Chantelb
9 - Comet
Spoiler
Chantelbbr_0-1577056088894.png
wwatson
12 - Quasar

My solution