Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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

wdavis
Alteryx Alumni (Retired)

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
Managing Partner
DCG Analytics
TonyA
Alteryx Alumni (Retired)

Here's my solution.

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 17 is done!

 

Révélation
challenge 17 JMS macro solution.PNGchallenge 17 JMS solution.PNG
JennyMartin
Comète
Révélation
AWC17.PNGAWC17M.PNG

Great for batch macro practice.

Bluemoon
Astéroïde

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

Révélation
clipboard_image_0.png
Koji_B
Astéroïde

Solution attached.

 

Answer requires % closed rather than % retained

jusdespommes
Astéroïde

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 🙂

 

Révélation
WeeklyChallenge17.PNGWeeklyChallenge17b.PNG
ArnavS
Alteryx Alumni (Retired)
 
Assaf_m
Bolide

Solution attached