--- id: attendance-analysis name: Attendance Analysis description: Analyse workforce attendance, lateness and absence, and compare people and departments. category: workforce pages: - analytics - control-center status: active version: 1 triggers: - attendance - absence - absences - absenteeism - late arrival - missed shift - missed shifts owliver: enabled: true suggestions: - label: How is attendance? capability: summary - label: Compare attendance by person capability: table - label: Attendance over recent periods capability: flow capabilities: - summary - stats - table - progress - flow - insight responses: summary: title: Attendance source: workforce.attendance stats: title: Attendance source: workforce.attendance table: title: Attendance by person source: workforce.attendance progress: title: Attendance by person source: workforce.attendance flow: title: Attendance over time source: workforce.attendance periods: - last-7-days - this-month - previous-month insight: title: Attendance source: workforce.attendance --- # Attendance Analysis ## Purpose - Report how reliably the workforce is turning up. - Separate turning up from turning up on time, because they have different causes. - Compare people and departments so a problem can be located rather than only counted. ## Capabilities - Summarize attendance, punctuality and missed shifts. - Compare attendance per person, worst first. - Show attendance across recent periods. ## Data Reads `workforce.attendance`, which counts `ShiftRecord` entries — every shift scheduled, whether it was worked, how late it started and how long it ran. Department is the position's `role_category`, the same field Hired History and Analytics group by. ## Analysis Attendance is the share of scheduled shifts that were **turned up for at all**, late or not. Punctuality is reported separately, as the share turned up for on time. Folding the two together would make a reliably-late team look absent and a genuinely absent one look better than it is. Minutes lost to lateness are reported alongside the count, because four late arrivals says nothing about whether it cost ten minutes or two hours. ## Output Headline attendance and punctuality rates, missed shifts split into absences and no-shows, and a row per person with their record. Over periods, one figure per window. ## Limitations - Only shifts that were scheduled are counted. Unrostered work does not appear. - A no-show and an absence are counted separately but both reduce attendance; the distinction is in the detail line, not in the headline rate. - The roster is whoever has shift records. This workspace has three, so a department average is one person's record — the per-person view is the more honest read at this size. - Excused absence is a recognised status but none is currently recorded.