Search

Close

Start Free Trial

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

My solution

Seems like using their first shift as starting date but fixed end date got me the closest results to expected

A little clunky but it works, including the Bonus question.

Here is my solution

Challenge 417.png

Solution

My Solution:

Screenshot 2024-03-12 133817.png

Screenshot 2024-03-12 133842.png

Screenshot 2024-03-12 133856.png

Formula(s):

Screenshot 2024-03-12 145313.png

Screenshot 2024-03-12 145313.png

Screenshot 2024-03-12 145313.png

Nice challenge. Here is my solution.

Alteryx Challenge 417 Solution.png