This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.
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).
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!)