Challenge #17: Month-over-Month Retention Rate

[Hammad_Rashid]

[ed_hayter]

Spoiler

[jennifer_owens]

So I took this one step further and created an app and macro so a user to select the months they want to include/exclude. So if you select April-August, you will get the same final output, but this will be more dynamic in adding new dates. It was a challenge to get it to work! 

[Yoshiro_Fujimori]

My solution.

It took some time to understand what is counted as "Open"...

Spoiler

Workflow

Macro

[sp210708]

This one was challenging

[chandler-gjino]

attaching my solution

[lucascs]

Workflow:

Spoiler

Macro:

Spoiler

[lucaskro]

Spoiler

[tristank]

Love the macro challenges. Nothing was being output from the macro and I was going crazy. Turns out I just had to update Alteryx and then the bug was fixed! (Extra notes in spoiler!)

Spoiler

The language for the opened and close was misleading and confusing. I changed the % calc to be 1 - the active accounts to create a more accurate number for retention.

[LorenzNacilla]

Question was quite hard to comprehend at first, but eventually got there 

Spoiler

Spoiler