Weekly Challenge

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

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

Submit Feedback
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.

Challenge #17: Month-over-Month Retention Rate

Highlighted
Alteryx Certified Partner

Solved! Although not getting the same numbers as the output... My checks seem to add up for instance:

  • 2013-06-01 1/4 = 0.25: 
    • Open within prior 24 months = 4 (ID 1-4)
    • Closed in month = 1 (ID 4)

Output has 1/3. Also denominators are usually on the bottom. Great macro practice though! Feel like I got this one licked quite efficiently, assuming I'm correct!

Highlighted
Alteryx Certified Partner

Solution is attached.  Tried to go at this without a batch macro and was not getting very far.  The Batch macro simplified this greatly.

Highlighted
12 - Quasar

The tricky part here was realizing I shouldn't count accounts that had already closed.

 

Batch Macro:

Spoiler
macro.PNG
Highlighted
Alteryx Certified Partner

Definitely agree with others that the wording for closed/open accounts could be improved. 

Spoiler
Screen Shot 2017-11-12 at 02.55.04.pngScreen Shot 2017-11-12 at 02.54.52.png
Highlighted
Alteryx Partner

Very confused with the wording of the text...

Alteryx Certified Partner

I've uploaded 2 solutions, one with a generate rows and one with the batch macro

Highlighted
10 - Fireball

the retention percentage seems a little off. Seems it should be 1-% to get the true retention rate instead of reporting churn rate? Anyways good problem

Highlighted
11 - Bolide
11 - Bolide

A bit convoluted, but able to complete without using a macro.

Highlighted
8 - Asteroid

My solution.

 

Highlighted
Alteryx Certified Partner

Solution attached

 

Spoiler
challenge_17 - Snip.PNG