community
cancel
Showing results for 
Search instead for 
Did you mean: 
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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #41: Analytics PayPeriodCalc

Alteryx Partner

Wow, took me way too many tools to get this working but it is working!!!

Alteryx
Alteryx

Good DateTime and Generate Rows tools practice. 

Margarita Wilshire
Manager, Customer Support Engineering


Alteryx, Inc.
Asteroid
 
Meteor
 
Meteor

my steps are listed in the workflow

Atom
Spoiler
 

Here is my solution.  But I see many much more elegant solutions being posted.  Thank you everyone!

Alteryx
Alteryx

Solution attached. 

Alteryx
Alteryx

Parsed the dates using Date time tool, then used generate rows to fll in the gaps between start and end dates. Formula to add day and month, year information. Then again to mark weekdays and weekends. Filter out weekends summarize to find the total  counts per month.

Asteroid
Spoiler
Challenge 41 2019-11-29.jpg
Asteroid

My Effort

 

Spoiler
JamesCameron_0-1575012983007.png