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

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found hereWeekend Meme.png

 

This week's challenge was submitted by @NapasornCh  - Thanks for your submission!

 

Everyone has deadlines in business so it's natural to wonder how many working days you have left before time is up!

 

This week's challenge is to create a macro to calculate the number of business days between two user-selected dates, excluding both weekends and any dates specified by an optional input file. The included input file contains US holidays for 2021, as well as a few vacation days. Your macro should also allow the end-user to select the starting and ending date for the period.

Aaron_Harter
11 - Bolide

I'm already counting the days until the next holiday!

Spoiler
1.1.PNG
Macro configuration:
1.2.PNG

 

DaisukeTsuchiya
12 - Quasar
Spoiler
I created Analytic App with Macro. I think starting date is between Jan 23 to 25 not Jan 19 in sample output.

キャプチャ.JPG

キャプチャ2.JPG

 

 

DeanWest
9 - Comet

Looking forward to the next holiday!

 

Spoiler
challenge_252_solution_DeanWest-snippet_1.png
Spoiler
challenge_252_solution_DeanWest-snippet_2.png
patrick_digan
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1611588807055.png

 

clmc9601
12 - Quasar

@AYXAcademy, the output looks like it was configured to 1/25/21, not 1/19/21 as mentioned in the workflow instructions 🙂

 

Spoiler
Screen Shot 2021-01-25 at 8.47.29 AM.png
ggruccio
13 - Pulsar
13 - Pulsar

Fun with macros!  I often equate interfaces with apps, but this works too!  

 

ggruccio_1-1611589779927.png

Spoiler
Created start date and end date user inputs, used to generate rows.  Then used a formula to get to day of week....filtered out Saturday and Sunday.  Then created detour logic with check box interface for whether or not to include the optional file.

ggruccio_2-1611589879965.png

 

phottovy
12 - Quasar

Good way to start the week!

 

Spoiler
252.PNG
Kenda
15 - Aurora
15 - Aurora
Spoiler

 

Kenda_0-1611590847073.png

 


 

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
252.png252I.png