alteryx Community

# 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.

## Challenge #417: Evaluation of Employee Working Hours

Alteryx

Hi Maveryx,

A solution to last week’s challenge can be found here. The inspiration for this challenge was submitted by Nathan Purvis (@DataNath)  and was based on a Community discussion. Nathan, we appreciate your active participation in the Community!

March 31 marks the end of the first quarter of the year. During the following 2 weeks of April, your company is dedicating its time to evaluating their operational processes from the first quarter and suggesting improvements aimed at enhancing efficiency in the upcoming months.

The provided dataset contains information about the working shifts of all five employees, starting from their first day of work in January 2023 (not necessarily January 1), and spanning through March 31, 2023.

1. Build a table that displays each employee's total shifts during this period, the number of shifts that exceed 4 hours, shifts below 4 hours, and total non-work days.
2. For each employee, calculate the percentage of shifts that had fewer than 4 hours.

Bonus Question: In the event the company decides to expand its operations without bringing on new hires, which employee(s) (Employee_ID) should be considered for additional working hours?

If you need a little help, you can review these lessons in Academy:

Enjoy the challenge!

17 - Castor

My solution.

Spoiler

My results are slightly different from the sample output.

Bonus question :

Spoiler
Why the total days is different from each employee in sample output?

16 - Nebula
Spoiler
6 - Meteoroid

Hi folks,

This is my first time on first page of replies :D

17 - Castor

My solution to #417.

Spoiler
11 - Bolide

here's my take

Spoiler
9 - Comet
Spoiler
7 - Meteor

I didn't know about the Round() function handling portions of a percentage.  Glad I didn't try to recreate that wheel!

Spoiler
9 - Comet
Spoiler
Solution Attached

5 - Atom

My Solution