We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #17: Month-over-Month Retention Rate

apathetichell
16 - Nebula

The dataset feels kind of puny -this would definitely be a more fulfilling challenge if there were tons of entries. and maybe more data prep...

balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1621538394965.png

 

sara_burk
7 - Meteor

sara_burk_0-1623530150700.png

 

MichelleL
Alteryx
Alteryx

Great practice, thank you!

JasonHu
8 - Asteroid
Spoiler
workflow.pngmacro.png

Here is my submission.

hoadinh
6 - Meteoroid

My solution:

dhavaldoshi
8 - Asteroid

How to do it as a beginner?

  • Do not fret to over use filters/tools when you are learning, especially with AND logic, infact it is more efficient that way!

Think of it as filtering a 100 rows on 3 conditions at once

OR

100 with one condition, 30 with another, 10 with third

The second one is always better

 

  • Batch Macro: Always helps repeat tasks if you want to do it for a group. In this case start of month, please understand this is the difference between a standard a batch macro.

 

Spoiler
Solution_17 Macro.PNGSolution_17.PNG

 

 

ExploreMore
8 - Asteroid
Spoiler
Screenshot 2021-07-18 022856.png

DanTh
Alteryx
Alteryx
Spoiler
This took me quite a while to puzzle through. I decided the best approach was for me to make a single workflow that worked for one month, then I started putting the Batch Macro together to iterate through the other months. I had an error which was showing I was passing a Date field through my numerical Months filter, so had to do some digging to find the right parameter in the Macro block.

4/5
mnmemilymnm
7 - Meteor

My solution