community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #86: Create a Macro that Generates Past Dates

Meteor

It's definitely not best practice, but here's one way of doing this:

 

Spoiler
Capture.PNG
Bolide

That was fun! Cheers!

Alteryx Partner

My verbose approach. I like more the versions with detour that I've seen above.

 

Spoiler
Main.pngMain Workflowmacro.pngMacro

 

Asteroid
 
Asteroid

Here is my solution...

 

I had to change the extensions to upload...

Alteryx Certified Partner

Here is my solution:

 

Spoiler
challenge86.jpg
Atom

Challenge #86.PNGHere is my solution

Alteryx Certified Partner

Nice and straightforward with 'Generate Rows' tool!

Fireball

This was good macro practice, and not too bad considering the Advanced tag!

 

Spoiler
After looking at others' solutions, I'm going to go back and try this with Detour tools, which I've never used.

I handled the skip-weekends option within the Generate Rows formula
challenge_86_macro.PNG


challenge_86_generate_rows.PNG
Alteryx Partner
Spoiler
WC86.PNG

my solution