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
Great challenge, I really enjoyed this one.
I think mine is different to most as I wanted to avoid using the "Generate Rows" tool as this brute force approach, while very useful in given circumstances, can massively increase the data size. So, I used something else...
Spoiler
I first transposed the data to get the dates in a single column, I then used the date parse tool to convert the date into a date format. With this new date, I created the "Month" column.
Now here's where it gets interesting (if you don't get out much, obviously), I split the streams, the first I cross-tabbed back to I had the P1 and P2 start and end dates in columns; the second I generated the days of the week, and filtered to only show those that were weekend days. I then applied the "Count Workdays" tool, and fed in the weekend days as the restriction list.
Simple.
Now here's where it gets interesting (if you don't get out much, obviously), I split the streams, the first I cross-tabbed back to I had the P1 and P2 start and end dates in columns; the second I generated the days of the week, and filtered to only show those that were weekend days. I then applied the "Count Workdays" tool, and fed in the weekend days as the restriction list.
Simple.
Spoiler
I found this article useful for getting the day of the week from the dates - https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm
I found this article useful for getting the day of the week from the dates - https://help.alteryx.com/10.1/Reference/DateTimeFunctions.htm
