ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. 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 #41: Analytics PayPeriodCalc

MikeLR
9 - Comet
‎07-08-2020 07:02 AM

Not a very elegant solution and definitely makes me wish that weekdays was an allowed unit in DateTimeDiff ...

Spoiler
MikeLR_0-1594216916799.png

 

 

challenge_41_soln_MikeLR.yxmd
Reply
Normster
8 - Asteroid
‎07-08-2020 12:20 PM

My solution was similar to the provided solution.

Spoiler
Normster_0-1594236015383.png

 

Reply
treepruner
9 - Comet
‎07-14-2020 07:24 PM

I really think I have too many steps to do this!

challenge_41_start_file.yxmd
Reply
Lucatelli
8 - Asteroid
‎07-15-2020 09:19 PM

Pleae find attached my proposed solution.

challenge_41_start_file_solutiuon_Lucatelli.yxmd
Reply
troyeb4
8 - Asteroid
‎07-16-2020 10:46 AM

This one took some thinking. I liked it. Now I have a few formulas stored away.

Spoiler

troyeb4_0-1594921363453.png

 

challenge_41_solution_troyeb4.yxmd
Reply
psampaio005
8 - Asteroid
‎07-18-2020 08:50 AM

I"m pretty sure I could save some tools.

Spoiler
#41 - Solution - PS.JPG
challenge_41_PS_solution.yxmd
Date_Time.xlsx
Reply
FlorianC
Alteryx
Alteryx
‎07-23-2020 04:19 PM

Simple challenge, yet not as straightforward as one would expect. I wish there was a date-time function managing weekends.

 

Spoiler
WorkflowWorkflow
Florian Carrier
Strategic Solution Consultant
Alteryx
Challenge #41.yxzp
Reply
balajilolla
8 - Asteroid
‎07-25-2020 11:42 AM
Spoiler
Solution Attached

balajilolla_0-1595702522694.png

 

challenge_41_start_file.yxmd
Reply
JoePC
9 - Comet
‎07-28-2020 02:33 AM

Solution Attached

41.yxmd
Reply
carmenrapariz
8 - Asteroid
‎07-30-2020 07:16 AM
Spoiler
Challenge 41.PNG
Challenge week 41.yxmd
Reply