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
8 - Asteroid
Spoiler
Challenge17.JPG
Highlighted
8 - Asteroid

I always struggle to come up with use cases for Iterative & Batch macros. This is a great example of a batch macro.

Highlighted
8 - Asteroid
Spoiler
igorp_0-1586776742856.png

 

Spoiler
igorp_1-1586776757842.png

 

Highlighted
Alteryx Partner

Done

Spoiler
Annotation 2020-04-15 143848.pngAnnotation 2020-04-15 143819.png
Highlighted
Alteryx Certified Partner

Here is my solution !

Highlighted
Alteryx Partner

Hi,

 

Here's my solution. I still can't understand what the Batch Macro could do more than a simple WF.

 

Spoiler
Capture d’écran 2020-04-19 à 20.34.16.png

Cheers

Amr

Highlighted
8 - Asteroid

Please find attached my solution.

Highlighted
8 - Asteroid

Here is my solution

Spoiler
WeeklyChallenge_Ryohei_17.JPGWeeklyChallenge_Ryohei_17_Macro.JPG
Highlighted
8 - Asteroid

Here is my solution. I quickly set up a normal workflow as solution. Struggled a little bit with the open definition.

Spoiler
Sylvana_0-1587992502233.png

 

Then I changed it to a macro.

Spoiler
Sylvana_1-1587992572996.png

 

Highlighted
7 - Meteor
Spoiler
jenniferk_0-1588224060628.pngjenniferk_1-1588224076540.png

 

 

Struggled to get the right conditions to count the number of opened per month and realized that you should not leave extra empty rows in the macro input to update. Won't be forgetting this lesson anytime soon.