Skip to main content
DD-HRM-003 Mizan Group: 1,000 People, One Payroll — HR & Payroll Analytics Get the data →
DD-HRM-003-Q021 Medium

Late arrivals in 2025

A late arrival is a "Present" row whose ClockIn is more than 5 minutes after the ScheduledStart of its shift (DimShift) on the WorkDate. How many late arrivals were there in 2025?
Expected
One whole number · KPI card
Tables
FactAttendance, DimShift · columns
  • FactAttendance
  • DimShift
  • ClockIn
  • WorkDate
  • ShiftCode
  • ScheduledStart

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

Create a free account Sign in