Skip to main content
DD-HRM-004-Q016 Medium

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
  • FactClockEvent
  • DimTerminal
  • DimHoliday
  • EventType
  • EventTime
  • TerminalID
  • SiteType
  • HolidayDate
  • DayType

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