ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

danbostrom
8 - Asteroid

 

 

calvingao
7 - Meteor

Challenge 17

LorraineF
7 - Meteor

Practicing some batch macros

asultanov
8 - Asteroid
Spoiler
Screenshot 2024-03-15 160244.pngScreenshot 2024-03-15 160257.png
Erin
11 - Bolide

submission attached

Bobbyt23
13 - Pulsar

Tricky little challenge for what I thought would be simple. Enjoyed it.

aatalai
15 - Aurora

slightly different numbers, more in methodology I think as when I did it manually for one month still got some variances

Bren_Spill2
12 - Quasar
12 - Quasar
Spoiler
#17 WF.JPG#17 Macro.JPG

Rhys_Cooper
11 - Bolide

bit of a tricky one to deduce the required logic from the instructions but good macro practice

 

Spoiler
Screenshot 2024-05-22 165048.png

 

Screenshot 2024-05-22 165106.png

 

vmazur24052020
8 - Asteroid

Batch Marco is little bit tricky in terms of input data grouping.

It looks like example data in the start file is wrongly calculated (# of open a/cs is not correctly calculated if you take 24-month rolling count).