From the clock to the gate
Gated sites are those with a "Gate" terminal in DimTerminal (distribution centres, plants, the warehouse and the depots). Pair each "Clock in" event with the "Clock out" of the same employee and AttendanceDate; its roster line is the employee's FactRoster row with RosterDate = that AttendanceDate; a Clock in belongs to the year and month of its AttendanceDate. For Clock ins of 2025 at gated sites, take the same employee's "Gate out" with the same AttendanceDate. What is the average number of minutes from the Clock out to the Gate out? 2 decimals.
- Expected
- One number, 2 decimals · KPI card
- Tables
-
FactClockEvent, DimTerminal · columns
- Topics
- Workforce & Payroll