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

Challenge #417: Evaluation of Employee Working Hours

youchun
6 - Meteoroid

Here's my solution

Ray_Pospisil
8 - Asteroid

Alteryx, SQL, pandas solution

franc1s
8 - Asteroid

I really like the fact that you included the three solutions! Particularly interested in the pandas solution.

 

In terms of the ALteryx solution, I like it for its simplicity!

Seba
7 - Meteor

Bonus Question: it should be Employee IJ345

 

Challenge 417.jpg

Total Shift Taken.jpg

Shift above 4.jpg

Percentage below 4 hours.jpg

Non work days.jpg

Percentage below 4 hours.jpg

roryor11
5 - Atom

My solution

Axelar
8 - Asteroid

#Solution

swethamadesh
5 - Atom

Here is my solution Workflow. 

Spoiler
 

Alteryx 417.JPG

 

davidhardister
8 - Asteroid
Spoiler
Capture.PNG

Carolyn
12 - Quasar
12 - Quasar

Solved! I used "round" instead of "smartround" so my solution didn't quite match the answer. I also got my RegEx Parse almost on the first try - I was missing a "-". Very excited about getting better at RegEx!

 

Also, I think the instructions were a bit unclear about what to do with shifts exactly 4 hours since they're neither above nor below 4 hours but the solution treated them as below 4. 

 

Spoiler
2024-04-26_12-44-39.png

sophiezero
7 - Meteor

I start with the weekly challenge 424 and come back for the old ones and get addicted to them! So much fun and also could see the solutions from different people, learned a bunch of new things, so cool!