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
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:
- 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.
- 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!
I didn't know about the Round() function handling portions of a percentage. Glad I didn't try to recreate that wheel!
My Solution
