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

nickjastrzebski
8 - Asteroid

Workflow

Spoiler
image.png

 

Macro

Spoiler
image.png
Greg_Murray
12 - Quasar

solution attached

jagdeep_singh85
8 - Asteroid

PFA my solution

mpennington
11 - Bolide

Solution attached.  This one was not easy for me, struggled to get the iterative macro right. I was able to get a standard workflow developed without issue, but I guess I need more work on developing iterative macros. 

 

Spoiler
Workflow PortionWorkflow PortionIterative MacroIterative Macro
Johnny_Analytics
8 - Asteroid
Spoiler
Challenge_17_solution.pngChallenge_17_macro.png
Cosmin_S
8 - Asteroid

My solution is attached.

Thank you. 

DavidW
Alteryx Alumni (Retired)
Spoiler
Screenshot.png
David Wilcox
Senior Software Engineer
Alteryx
RWvanLeeuwen
11 - Bolide

Here we go!

Spoiler
A little data preparation before using the macroA little data preparation before using the macro

Spoiler
The Close formula is quite simple, but the open formula should take into account that an account should not be counted in the month after it has closed. Luckily the intended results were available for validating the outcomeThe Close formula is quite simple, but the open formula should take into account that an account should not be counted in the month after it has closed. Luckily the intended results were available for validating the outcome
lavanyadurai
7 - Meteor
Spoiler
Challenge17b.PNG

 

Challenge17a.PNG

 

alexo
8 - Asteroid

Change my view: A batch macro is just a fancy more complicated way of using an append fields and other tools with grouping capabilities.