Skip to main content
DD-HRM-004-Q013 Medium

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
  • FactClockEvent
  • DimTerminal
  • EventType
  • EventTime
  • EmployeeID
  • TerminalType

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us