Ramadan hours in the stores
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 in" events at Store terminals on the Ramadan days of 2025 (DimHoliday), what is the average number of hours from Clock in to Clock out? 2 decimals.
- Expected
- One number, 2 decimals · KPI card
- Tables
-
FactClockEvent, DimTerminal, DimHoliday · columns
- Topics
- Workforce & Payroll