Workflow · People · Opening soon
Absenteeism rate
Use a BambooHR export to calculate absenteeism rate by department and month. The result groups absence and workday data into a clear monthly view.
Someone typed
“calculate absenteeism rate by department and month from unplanned absence days and scheduled workdays”
The agent read it as
Calculate absenteeism rate by department and month from BambooHR custom report: Department absence summary.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
BambooHR custom report: Department absence summary
CSV export · 18 rows
Step
Calculate absenteeism rate
Step 1
Result
Department Absence Rates
18 rows
Schedule
Runs when you say
Proposed
- FileBambooHR custom report: Department absence summaryCSV export · 18 rows
- StepCalculate absenteeism rateStep 1
- ResultDepartment Absence Rates18 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 18 rows came out.
- Download BambooHR custom report: Department absence summary sample (18 rows)BambooHR: Reports > Create Report > Custom Report > add Department, Month, Scheduled Workdays, and Unplanned Absence Days > Export CSV
What you get back
The result of that run, the rows to look at first.
Department Absence RatesSample data18 rows
| Department | Month | Absenteeism rate | Unplanned Absence Days | Scheduled Workdays |
|---|---|---|---|---|
| Accounting | 2026-08 | 2.3 | 2 | 86 |
| Accounting | 2026-09 | 1.1 | 1 | 88 |
| Accounting | 2026-10 | 0 | 0 | 90 |
| Customer Support | 2026-08 | 3.6 | 6 | 168 |
| Customer Support | 2026-09 | 2.9 | 5 | 170 |
| Customer Support | 2026-10 | 8.1 | 14 | 172 |
| Engineering | 2026-08 | 0.6 | 1 | 176 |
| Engineering | 2026-09 | 1.1 | 2 | 180 |
| Engineering | 2026-10 | 1.6 | 3 | 184 |
| Finance | 2026-08 | 0 | 0 | 92 |
| Finance | 2026-09 | 1.1 | 1 | 90 |
| Finance | 2026-10 | 0 | 0 | 94 |
How do you calculate absenteeism rate by department and month?
Export the BambooHR custom report for Department absence summary. Then use the workflow to calculate absenteeism rate from the absence days and scheduled workdays in that file. The result is a table of absenteeism rates by department and month.
How it works
How to use the Department Absence Rates workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Department Absence Rates: questions
What export should you use?
Use the BambooHR export that contains the department, month, absence days, and scheduled workdays you want to use in the calculation. If the needed fields are not in the file, the workflow cannot calculate the rate.
What happens to rows that do not match?
Rows that do not contain the values needed for the step are not used in the result. You can fix the source export and run the file again if you want them included.
How do you change the rules?
Edit the workflow step in words, for example by changing the fields, grouping, or calculation you want. Then rerun the export through the updated workflow.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Match payroll to time sheets, track headcount and hiring, and see what changed since last month.
- Resource capacity by weekCompare booked project hours to weekly availability in an Excel export and show who is over or under capacity.See the workflow Built by the agent
- Salary bands compa-ratioExport employees from BambooHR, pair them with salary bands, and work out each employee's compa-ratio against the band midpoint.See the workflow Built by the agent
- On-time shipping rateCalculate on-time delivery rate from a ShipStation shipments export, grouped by carrier and week.See the workflow Built by the agent
- PTO balance reportShow each employee’s PTO accrued, taken, carryover, and remaining balance this year from BambooHR exports.See the workflow Built by the agent
- Billable utilization by employeeCalculate each employee's utilization rate by month from exported Harvest time entries and capacity files.See the workflow Built by the agent
- Employee turnover rateCalculate monthly employee turnover rate by department from a BambooHR employee export, with turnover, cleaned department names, and a status check.See the workflow Built by the agent