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