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

jasperlch
12 - Quasar

Solution attached.

michalsicak
7 - Meteor

This challenge showed me there's still a lot to work for me to improve on UI and macros in Alteryx.

 

Spoiler
challenge17.png
aclaxton
8 - Asteroid

Finally got it working! I took a much different route than other answers but I was trying to keep it dynamic...

Spoiler
Week 17.pngWeek 17Macroi.png
jamielaird
14 - Magnetar

This took me longer to nail than any other challenge so far; in particular the logic for the "Last 2 Years" number. Ended up writing and re-writing the logic as comments and trying different approaches until my numbers matched up.

 

Spoiler
Screen Shot 2017-12-24 at 11.37.53.png

 

 

DriveMyData
7 - Meteor

Week17.PNG

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

asabau
8 - Asteroid

Similar to the original solution.

kelly_gilbert
13 - Pulsar

I definitely need more practice creating macros, and this challenge was really helpful.

Note: the given solution is not consistent with the instructions.  The instructions say the calculation should be [Open] / [Closed], however, the given solution shows the % = [Closed] / [Open].

ivoller
12 - Quasar

Got there in the end!

Spoiler
2018-04-07_10-43-25.png2018-04-07_10-43-54.png
jsdeter
8 - Asteroid

Posting Solution