Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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

paul_houghton
12 - Quasar

Rocking through some more history

 

Spoiler
Challenge 17 macro.jpg
robbinrv
8 - Asteroid

Bit of a headache afterwards, but all done! good practice for real client problems.

 

Spoiler
Alt_Chal_17_2.PNGAlt_Chal_17_1.PNG

 

 

OllieClarke
16 - Nebula
16 - Nebula

My first Batch Macro :)

 

Spoiler
Challenge 17-1.PNGChallenge 17 - 2.PNG
akuma162
6 - Meteoroid

My Solution to this challenge

jevon
8 - Asteroid
Spoiler
challenge17 - 2 pic.pngchallenge17pic.png

I liked this one ;)

jxuan
7 - Meteor

#17 Solution

bdaniels
8 - Asteroid
 
AndrewRein
8 - Asteroid
 
CaraI
Alteryx
Alteryx

I originally put the date parsing in the macro, but then decided to pull them out just in case the date formats changed.  Turns out that move matched many of the solutions directly.  The calculations around open and closed took some experimenting and validation to get right.

 

Spoiler
Spoiler 17 Macro.jpg17 Workflow.jpg

 

kcoulon
8 - Asteroid

Challenge solved - was on the right track but just need a little help from the solution file!  Thanks for more batch macro practice!