Workflow · People · Opening soon

Employee turnover rate

See monthly employee turnover rate by department from your BambooHR employee export. The workflow cleans department names, calculates turnover, and flags rows that do not look right.

Book a demo

Someone typed

“show every department by month from the bamboohr employee export, fixing customer sucess to customer success, with turnover as leavers divided by average headcount and a Status that says "Agrees" when it looks right, else why”

The agent read it as

show every department by month from BambooHR employee export, fixing customer sucess to customer success, with turnover as leavers divided by average headcount and a Status that says "Agrees" when it looks right, else why

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

BambooHR employee export

CSV export · 25 rows

Step

Turnover by month

Step 1

Result

Department turnover by month

18 rows · 1 flagged

Schedule

Runs when you say

Proposed

File
BambooHR employee export
CSV export · 25 rows
Step
Turnover by month
Step 1
Result
Department turnover by month
18 rows · 1 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 18 rows came out.

Download BambooHR employee export sample (25 rows)BambooHR: Reports > Custom Report > Employees > Export CSV

What you get back

The result of that run, the rows to look at first.

Department turnover by monthSample data18 rows

17 agrees1 no headcount

Month	Department	Headcount start	Headcount end	Leavers	Average headcount	Turnover	Status
2026-09-01	People Operations	0	0	0	0	·	No headcount
2026-09-01	Customer Success	0	1	0	0.50	0	Agrees
2026-10-01	Customer Success	1	2	1	1.50	0.67	Agrees
2026-09-01	Engineering	0	2	0	1	0	Agrees
2026-10-01	Engineering	2	3	1	2.50	0.40	Agrees
2026-09-01	Finance	0	1	0	0.50	0	Agrees
2026-10-01	Finance	1	3	0	2	0	Agrees
2026-09-01	HR	0	1	0	0.50	0	Agrees
2026-10-01	HR	1	1	1	1	1	Agrees
2026-09-01	Marketing	0	1	0	0.50	0	Agrees
2026-10-01	Marketing	2	3	0	2.50	0	Agrees
2026-09-01	Operations	0	1	0	0.50	0	Agrees

18 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you calculate employee turnover rate by department?

Export your employee file from BambooHR and load it into the workflow. It groups each month by department, fixes names like customer sucess to customer success, and calculates turnover as leavers divided by average headcount. Each row gets a Status field, which says Agrees when the result looks right, or shows why it does not.

How it works

How to use the Department turnover by month 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 turnover by month: questions

Which export should you use?

Use the employee export from BambooHR. It should include the fields needed to identify department, month, leavers, and headcount.

What happens to rows that do not match the rule?

Rows that do not match stay in the result, but they are marked with a Status value that explains why. For example, a row can say No headcount if the workflow cannot find headcount for that month or department.

How do you change the rule in words?

Edit the rule description in plain words, then rerun the workflow on a fresh export if needed. For this page, the rule is monthly employee turnover by department, with turnover calculated as leavers divided by average headcount.