Workflow · People · Opening soon
Gender pay gap
See pay gap analysis across job level and department from a BambooHR export. Keep Salary and Hourly pay separate, and compare average and median pay by gender.
Someone typed
“compare average and median pay by gender within each job level and department”
The agent read it as
Compare average and median pay by gender within each job level and department for BambooHR custom report - Employee compensation, keeping Salary and Hourly pay separate.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
BambooHR custom report - Employee compensation
CSV export · 24 rows
Step
Compare pay by group
Step 1
Result
Pay By Gender
24 rows
Schedule
Runs when you say
Proposed
- FileBambooHR custom report - Employee compensationCSV export · 24 rows
- StepCompare pay by groupStep 1
- ResultPay By Gender24 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 24 rows came out.
- Download BambooHR custom report - Employee compensation sample (24 rows)BambooHR: Reports > Create New Report > Employee Fields > export CSV
What you get back
The result of that run, the rows to look at first.
Pay By GenderSample data24 rows
| Gender | Job Level | Department | Pay Type | Average pay | Median pay |
|---|---|---|---|---|---|
| Female | L1 | Engineering | Salary | 82,000 | 82,000 |
| Female | L1 | Marketing | Salary | 64,000 | 64,000 |
| Female | L1 | Sales | Salary | 62,000 | 62,000 |
| Female | L1 | Support | Hourly | 23.50 | 23.50 |
| Female | L2 | Engineering | Salary | 98,000 | 98,000 |
| Female | L2 | Marketing | Salary | 77,000 | 77,000 |
| Female | L2 | Sales | Salary | 86,000 | 86,000 |
| Female | L2 | Support | Hourly | 31 | 31 |
| Female | L3 | Engineering | Salary | 132,000 | 132,000 |
| Female | L3 | Marketing | Salary | 103,000 | 103,000 |
| Female | L3 | Sales | Salary | 118,000 | 118,000 |
| Female | L3 | Support | Salary | 92,000 | 92,000 |
How do you compare average and median pay by gender within each job level and department?
Export a BambooHR custom report for employee compensation, then load it into the workflow. It compares average and median pay by gender within each job level and department, and keeps Salary and Hourly pay separate.
How it works
How to use the Pay By Gender 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.
Pay By Gender: questions
What export should you use?
Use a BambooHR custom report export for employee compensation. Export the fields you need for pay, gender, job level, and department.
What happens to rows that do not match the grouping rules?
Rows that do not match a group are left out of that grouped result. They stay in the file, but they do not affect the averages or medians for groups they do not fit.
How do you change the rules?
Edit the grouping words in the workflow. You can change which columns define the groups, such as job level, department, or pay type.
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