Challenge #417: Evaluation of Employee Working Hours

[CSmith16]

@DataNath How did you get your data to be sorted in the right order after the summarize tool? I have even replicated yours on a new worksheet and it doesn't sort the same. I had to add in a column then remove it to sort it the same as the solution. I have even copied your tools into my workflow and they don't sort the same.

Edit: When I disable AMP, the summarize tool rearranges the sort order of the Employee ID every time I make a run.

---

---

Spoiler

[olga_strubbe]

Thank you, @DataNath, for a a neat challenge! 

My non-working days are slightly different from yours - I did not discount for the start of the first working day: I calculated how many total days from Jan 1 to Mar 31st and subtracted the days worked, as if the folks did not work right away on Jan 1st, I still counted it as their non-work day(s). 

I've also did a check to see if any of the shifts were worked on the same day (which did not take place in this scenario), but I wanted to verify to come up with a clean answer as to the number of non working days in Qtr 1 2023. 

Hope this works.  Thanks again for the challenge! :)

[Clem_]

Just starting to learn Alteryx. First time poster. My results are a little off. Not sure where the issue is. Any help would be greatly appreciated. And just to note, since there were no shifts with zero work hours, I assume that no one worked on weekends. Thanks in advance. 

[TurboToad]

Here's what I put together. Calculated the total # of hours and sorted for the bonus question. 

Spoiler

[CSmith16]

@Clem_ 

To get the same results for lower than 4 hours, you need to put an equals sign for lower than 4, you want all shifts less than OR equal to 4.

As for non working days, you can get that a bunch of different ways but the way you did it is not one. You need to find the minimum date for each employee and datediff against the start of April (because you need to include 3/31) then subtract days worked from that total.

And for the percentage below 4, you need to round either to the nearest .5 or just use the smart round function.

Spoiler

What you put:

Fixed:

 

 

[Clem_]

@CSmith16

OHHHHH!!!!  Makes sense. Much appreciated. Thanks

[nadasky]

My solution.

[ShawnHendersonCPA]

My take on the solution!

 

[Shaktikdhar]

Spoiler

Bonus Questions

[lukas_olsovsky]

Thank you for your, yet again, fun challenge :) Running time 0,4sec

Spoiler