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. Thanks, @Tony_Castillo !
Workflow:
Spoiler
I tried to make mine somewhat dynamic, in case we had a much larger/more complex list of employees.
For a large list of employees, it would be more efficient to do the Cartesian product on employees x holidays rather than employees x all days (as I did here). We'd just need to make sure we don't drop employees who either didn't have any holidays in their region (or didn't match to an available holiday list).
For a large list of employees, it would be more efficient to do the Cartesian product on employees x holidays rather than employees x all days (as I did here). We'd just need to make sure we don't drop employees who either didn't have any holidays in their region (or didn't match to an available holiday list).
Bonus:
Spoiler
I know I could have just counted the results from the report output, but this was an opportunity to bring out this crazy-but-useful formula from @jdunkerley79 (which I learned about from a previous weekly challenge!)
A fun challenge and a great example of the Generate Rows tool!
Always copy and paste the date example whenever I come across a challenge like this!
