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

wdavis
Alteryx
Alteryx

Completed with the Macro addition

Treyson
13 - Pulsar
13 - Pulsar

I added a bit to this, where if you so desired you can have the workflow continue to change the ranges that it's checking for as time goes on. That way, when we are running this next month, we don't have to add any parameters to our text input table.

Treyson Marks
Senior Analytics Engineer
TonyA
Alteryx Alumni (Retired)

Here's my solution.

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 17 is done!

 

Spoiler
challenge 17 JMS macro solution.PNGchallenge 17 JMS solution.PNG
JennyMartin
9 - Comet
Spoiler
AWC17.PNGAWC17M.PNG

Great for batch macro practice.

Bluemoon
8 - Asteroid

A bit messy, but gets the job done...

Spoiler
clipboard_image_0.png
Koji_B
8 - Asteroid

Solution attached.

 

Answer requires % closed rather than % retained

jusdespommes
8 - Asteroid

This one broke me - I think it would have been a lot easier if the rules were bulleted at the start i.e. if closed before then can't be open in the future etc.

 

Ended up using an iterative macro. All done anyway 🙂

 

Spoiler
WeeklyChallenge17.PNGWeeklyChallenge17b.PNG
ArnavS
Alteryx
Alteryx
 
Assaf_m
11 - Bolide

Solution attached