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

CoG
14 - Magnetar

Getting the Batch Macro was a little trickier for me than I anticipated. Great learning exercise!

 

Main Workflow:

Spoiler
Workflow_Main.png

 Batch Macro:

Spoiler
Workflow_BatchMacro.png
ds_tomalexsmith
8 - Asteroid
Spoiler
Challenge 17 (flow).pngChallenge 17 (macro).png

  

Rob-Silk
8 - Asteroid

My solution below:

Spoiler
challenge_17a_RS_screencap.PNGchallenge_17b_RS_screencap.PNG
Myles_Stevenson
8 - Asteroid

Here is the macro i made for the solution along with the workbook 

Spoiler
Screenshot 2023-12-04 144309.png

alexnajm
18 - Pollux
18 - Pollux

Done!

Spoiler
Challenge 17.PNG
caitlynmcintyre
9 - Comet

no need for a batch macro :)

 

Spoiler
17.png
BrianJohnson
8 - Asteroid

After starting exercise, I watched the interactive video again to help to turn it into a batch macro.  I went well and I appreciate the lesson.

sknman92
8 - Asteroid

my solution

SGrasland
7 - Meteor

I am finding macros to be a challenge! 

cecilysantiago
6 - Meteoroid