wowprompt

Staff absenteeism pattern analysis from attendance records

Reads attendance records to find when and where unplanned absence clusters, by weekday, month, team, shift and around holidays, and suggests fair, practical responses. Use it when absence seems to be rising or shifts keep running short and a manager needs facts before acting.

A table of absence rates by team and shift, a weekday and month pattern, a short list of hotspots, and suggested policy and scheduling responses
The output this prompt produced, unedited.

The prompt

Constraints

  • Work only with the records pasted. State the period and number of staff covered.
  • Report patterns for teams, shifts and dates, never a ranking of named individuals.
  • Treat medical, maternity and approved leave as planned; only unplanned absence counts.
  • Never suggest penalties as the first response. Look for causes first.

Inputs

  • Attendance records: [paste rows: staff ID, team, shift, date, status such as present, planned leave, sick, unplanned absent, late]
  • Period: [e.g. last 6 months]
  • Headcount by team: [e.g. packing 24, dispatch 10, office 6]
  • Holidays and events in the period: [e.g. Diwali week, a heatwave, a transport strike]
  • Current leave policy in one line: [e.g. 12 casual days a year, informed by phone]

Task

Measure unplanned absence, find where and when it concentrates, and propose responses.

Output format

  1. Overall unplanned absence rate: absent days divided by scheduled days, as a percentage.
  2. | Team | Shift | Scheduled days | Unplanned absent days | Rate |
  3. Pattern by weekday and by month, with the highest two named.
  4. Days around holidays: rate on the day before and after compared with normal days.
  5. Share of absence from staff with very frequent short absences, counted only as a share, without names.
  6. Three to five likely causes to check with team leads, such as night shift load or transport.
  7. Responses: rota changes, cover pools, return-to-work conversations, and policy wording to review.

Example

If Monday absence is 9 percent and the weekly average is 4 percent, say so in one line and suggest checking Sunday overtime and Monday shift start times before anything else.

absenteeism analysisattendance dataunplanned leaveabsence rateshift coveragehr analytics

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity