Calculating Headcount based on Labor Hour Report

I am trying to get a HC for each department from our labor hour reporting data. I was going to use a count function by employee name to be able to pull the number of workers for each department.

The challenge is for example:


Date Employee Department

10/12 Jon Fabrication

10/13 Jon Fabrication

How would I eliminate the duplicate names to ensure correct Headcount as well as not excluding names when they are needed. I do not know if this gets my point across but I am open for discussion.

Tagged:

Answers

  • Hi @gbrown try using COUNT(DISTINCT(`employee name`)) in a beast mode to count the number of unique employees.