Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #252: Working Days Remaining

Renato_7
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
8 - Asteroid

Fun exercise! 

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

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
ACE Emeritus
ACE Emeritus

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
16 - Nebula
16 - Nebula

Here is my solution !