In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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

kelly_gilbert
13 - Pulsar
‎02-02-2021 11:35 AM

My solution is pretty similar to the others, except I gave the user the option to select which weekdays to exclude.

 

Macro interface:

Spoiler
kelly_gilbert_1-1612294248223.png

 

Macro:

Spoiler
kelly_gilbert_2-1612294485339.png

Outer workflow:

Spoiler
kelly_gilbert_0-1612294125119.png
challenge_252_solution_klg.yxzp
Reply
0 Likes
Nicholas_Norton
8 - Asteroid
‎02-03-2021 09:06 PM

I guess I need some practice with Macros again! This one took me a couple of hours. 😅

Spoiler
snaps56_0-1612415193066.pngsnaps56_1-1612415200097.png

 

challenge_252_NN.yxzp
Reply
0 Likes
jamielaird
14 - Magnetar
‎02-04-2021 10:41 AM

Here's my solution:

 

Spoiler
jamielaird_0-1612464065580.png
jamielaird_1-1612464073119.png

 

jamielaird_2-1612464084166.png

 

 

challenge_253_solution_JL.yxmd
Reply
0 Likes
Tisaac95
8 - Asteroid
‎02-09-2021 07:18 AM

My solution

252 complete.yxzp
Reply
0 Likes
MattBenj
10 - Fireball
‎02-12-2021 12:40 PM

Pretty simple one this week.

Reply
0 Likes
rmassambane
11 - Bolide
‎02-19-2021 06:04 AM

Our work is never over.

challenge_252.yxmd
Reply
0 Likes
PhilipMannering
16 - Nebula
16 - Nebula
‎02-21-2021 07:57 AM

Next step is to scrape x to dynamically remove public holidays for the chosen time period.

 

Spoiler
macromacro
Challenge 252 - Working Days Remaining.yxmc
Reply
TomWelgemoed
12 - Quasar
‎02-22-2021 12:08 AM

Like that you added the Error message - easy to forget.

Reply
0 Likes
rcarog
8 - Asteroid
‎02-26-2021 01:32 PM

Solution attached.

challenge_252_solution.yxzp
Reply
0 Likes
JosephSerpis
17 - Castor
17 - Castor
‎02-28-2021 07:26 AM

Challenge Completed

 

Spoiler
Challenge_252.JPG
challenge_252_Joe_Serpis.yxzp
Reply
0 Likes