Absenteeism report by department and day

How it works

1. Open Attendance Analytics, pick a month and scroll to the absence grid.
2. Departments run down the side and the days of the month across the top.
3. Each cell counts people graded absent that day: a working day with no punch, or a day too short to count.
4. Days covered by approved leave are graded as leave, so they do not add to the grid.
5. The month totals show absent days next to late days and late marks.
6. Filter to one department, then open the day log in Attendance Punches to see individual days.

What you can set

• Grid: departments by days for one month.
• Absent day: a working day graded absent under your attendance rules.
• Department filter for a closer look at one team.
• Days after today left out.
• Month totals for absent days, late days and late marks.
• Same grading as the payable days sent to payroll.

Reading absence patterns

Absence tells a story when you see it laid out by day. A column of high numbers on a Monday suggests weekend travel or a transport problem. A block after a festival shows staff who went home and came back late. One department that is always absent more than others may have a supervision problem, a health issue or simply too few people. Seeing the grid first keeps the discussion on causes rather than on blaming individuals. The absenteeism rate formula is in HR metrics.

Worked example: a packaging plant in Baddi

HR at a pharma packaging plant in Baddi opens November's grid. The printing department, 38 people on a 6 am shift, shows 9 absent on Monday 2 November and 11 on Monday 16 November, while dispatch and quality stay at one or two most days. Talking to the printing supervisor, HR learns that many printing operators travel home to their villages at weekends and the Sunday night buses run late. The plant moves printing's Monday start to 8 am for a trial month. December's grid shows Monday absence in printing back to the plant's usual level.

Acting on absence fairly

Numbers show where to look; people tell you why. Before treating a pattern as a discipline issue, check whether the process around it, from leave approvals to shift timings and transport, is creating absences that a small change could remove.

• Check whether leave was applied but not yet approved before calling a day absent.
• Hold a short return-to-work conversation after repeated absence.
• Watch your sandwich rule around weekly offs, which can add rest days between two absences.
• Use the grid again after any change to see if it worked.

Frequently asked questions