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

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

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.

 

Your tasks for this challenge are as follows:

 

  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!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
スクリーンショット 2024-03-12 004829.png

My results are slightly different from the sample output.
スクリーンショット 2024-03-12 004658.png



Bonus question :

スクリーンショット 2024-03-12 004833.png





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

スクリーンショット 2024-03-12 004648.png

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
417.jpg
ksukhraj
6 - Meteoroid

Hi folks,

 

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

DataNath
17 - Castor

My solution to #417.

 

Spoiler
417.png
RWvanLeeuwen
11 - Bolide

here's my take

Spoiler
417.png
nSpire
9 - Comet
Spoiler
417.png
oscar_leeper_wf
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
Challenge_417_solution.png
balajilolla2
9 - Comet
Spoiler
Solution Attached

Screenshot 2024-03-11 094052.jpg
KennethNelson
5 - Atom

My Solution

 

Solution_417.png