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.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #252: Working Days Remaining

RenatoV
6 - Meteoroid
Spoiler
Capture.PNG

SeanAdams
17 - Castor
17 - Castor

Great use of Alteryx - Holiday planning!

I did something similar to @ggruccio and included an option for the file on the interface.

result.png

 

Spoiler

Solution.png

 
MPard
6 - Meteoroid
Spoiler
MPard_0-1615232169954.png

This was a great exercise for getting into Macros and User input. I only had an idea of how to use them but now I have some experience! I included my macro and the workflow that runs the interactive app using the macro.

EDIT: I updated the flow to display properly in the interactive app.

Paulomi
7 - Meteor

Fun exercise! 

danicahui
8 - Asteroid
Spoiler
Macro with input option for holiday/leave dates:
Challenge 252 2021-03-11.jpg
Maskell_Rascal
12 - Quasar

First time using the Detour Tool. Fun challenge, but makes me wonder wish that Alteryx had an equivalent formula to Excel's Networkdays function. 

 

Spoiler
Workflow:
Maskell_Rascal_2-1615824382025.png


Macro:

Maskell_Rascal_3-1615824399812.png

 

NicoleJohnson
14 - Magnetar
14 - Magnetar

My solution!

  

Spoiler
Created a macro that allows user to pick start & end date, and then choose whether to exclude holidays or not (using holiday file that I embedded into the macro). 

WeeklyChallenge252.JPG

Working Days Calculator macro:
Challenge252Macro.JPG

Cheers!

NJ

jessle
8 - Asteroid
Spoiler
252.png
johnzrgu75
7 - Meteor

johnzrgu75_0-1616714720335.png

johnzrgu75_1-1616714761937.png

 

 

Jean-Balteryx
14 - Magnetar

Here is my solution !