Skip to main content
DD-HRM-004-Q041 Very Hard Time series

The latest stretch

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. A Clock in is late when it is more than 5 minutes after PlannedStart. Leave out Clock ins more than 3 hours away from the PlannedStart of their roster line (shift swaps) - from the count and from the total. For every month-end from March 2023 to September 2026, take the share of late Clock ins over that month and the two before it. Which month-end has the highest rolling share? yyyymm.
Expected
One month as yyyymm · KPI card
Tables
FactClockEvent, FactRoster · columns
  • FactClockEvent
  • FactRoster
  • EventType
  • EventTime
  • PlannedStart

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