Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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
Spoiler
To handle csv format, parsed header and data separately and rejoined using field info and dynamic rename to create dataset.
Included a Boolean test on > 4-hour shifts and aggregated by count of results into the view.
The dataset does not include days the store is not open (no employee was paid). To count these days in non-working days, find employee's first shift date (assumes the employee's first shift is first date of employment) and join to view.
Datetime delta of start date to EOM less total shifts taken is non-working days.
Straightforward with assumptions.
Included a Boolean test on > 4-hour shifts and aggregated by count of results into the view.
The dataset does not include days the store is not open (no employee was paid). To count these days in non-working days, find employee's first shift date (assumes the employee's first shift is first date of employment) and join to view.
Datetime delta of start date to EOM less total shifts taken is non-working days.
Straightforward with assumptions.
