The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
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
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

Tgigs
8 - Asteroid
‎09-13-2023 06:49 AM

My solution attached.

 

Was able to build a fully dynamic solution (meaning the input data could change and nothing else needs to change to get the correct result) WITHOUT the use of a macro and fairly simple design and not overly complicated.

Tgigs - Challenge 17 Solution.yxmd
Reply
0 Likes
mithily
8 - Asteroid
‎09-27-2023 02:54 PM
Spoiler
love batch macros
challenge_17_start_file.yxzp
Reply
0 Likes
markcurry
12 - Quasar
‎09-29-2023 09:35 AM
Spoiler
challenge_17_solution.png

 

challenge_17_mark.yxmd
challenge_17_macro.yxmc
Reply
0 Likes
TerrenceM
8 - Asteroid
‎10-03-2023 06:25 AM

Challenge 17

challenge_17_start_file.yxzp
Reply
0 Likes
toby49
8 - Asteroid
‎10-03-2023 07:53 AM
Spoiler
Screenshot 2023-10-03 155207.pngScreenshot 2023-10-03 155217.png

  

Challenge 17.yxzp
Reply
0 Likes
ArisaOkada
8 - Asteroid
‎10-04-2023 12:19 AM

My thirty-sixth workflow! I could finally get the same output. Macros, you confuse me so much...

challenge_17_start_file.yxzp
Reply
0 Likes
Computernerd
8 - Asteroid
‎10-09-2023 08:00 AM

This took me a while, but it helped me understand batch macros better.  I got it right, but slightly different than the example.

challenge_17_batch_macro.yxmc
challenge_17_Mine.yxmd
Sample Batch Macro (Weekly Challenge 17).yxzp
Reply
0 Likes
JXEC
7 - Meteor
‎10-12-2023 03:20 AM

Originally while making this, I had figured out the rough solution. The only issue was that I didn't exclude the right items, something that took a while to be fixed.

challenge_17_JXEC.yxzp
Reply
0 Likes
JBLove
10 - Fireball
‎10-13-2023 11:05 AM

Solution attached.

challenge_17_jbl.yxmd
Reply
0 Likes
MDestra
8 - Asteroid
‎11-08-2023 06:50 AM

Challenge #17: Month-over-Month Retention Rate

challenge_17_start_file-MD.yxzp
Reply
0 Likes