community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #41: Analytics PayPeriodCalc

Asteroid

Here is my solution

Asteroid

Cool problem to look at day counts in a different way outside of 7 days a week.

Spoiler
Challenge 41.PNG
Asteroid

my solution

Here's my solution to Challenge 41!

Alteryx
Alteryx

This is probably the toughest "Beginner" challenge I've seen so far. 

Spoiler
2019-02-27_11-50-06.png
I took a rules based approach. I built a formula to get the DOW then broke the problem into parts. The 15 day periods were easy -- if the period started with a weekend day, then there were 10 workdays, else there were 11. For the second part I found out how many 7 day periods there were and then did a conditional formula on the remainder to determine the number of weekdays. Then cleaned up the mess. It isn't pretty but it works.
Asteroid

completed using formula tool to convert to dates and then formula to calculate number of weekdays

Asteroid

Not as clean as I would have hoped, but it gets the job done.

Asteroid

Good one, I think my flow is not the most optimal option but it works

Asteroid

Completed, but with a significant debt of thanks to jdunkerly79's posting of ‎11-22-2017 12:10 AM. Now I wish to find out how to store this formula (and others) in my own function library.

 

 

 

 
Highlighted
Alteryx Certified Partner

Challenge #41, done.

 

Lazy solution (probably this could be done with a single formula tool, or a Multi-Field formula tool with a formula tool ahead of it).

 

Spoiler
Challenge_41.PNG

Cheers,