Skip to main content
DD-HRM-004-Q043 Very Hard

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

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