From the gate to the clock
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 each Clock in of 2025 at a gated site, take the same employee's "Gate in" with the same AttendanceDate. For the Clock ins whose Gate in came first, what is the average number of minutes from Gate in to Clock in? 2 decimals.
- Expected
- One number, 2 decimals · KPI card
- Tables
-
FactClockEvent, DimTerminal · columns
- Topics
- Workforce & Payroll