Employee Turnover Rate

Employee Turnover Rate: Percentage of employees who left in a period.

Formula

Turnover Rate = Employees departed / Average headcount × 100

Computable definition

The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.

count_distinct(field.employee_id where field.termination_date >= period_start and field.termination_date <= period_end) / ((metric.total_headcount at period_start + metric.total_headcount at period_end) / 2)

Unit: percent (the formula yields an unscaled ratio)

Breakdowns

by_department: one row per department value

Notes: Calculate monthly or annually. Annualize for comparability. Average headcount is the mean of start and end headcount. by_department returns one row per department: leavers and both headcounts are counted within the department, so attrition concentrated in one team shows.

Data requirements

Grain: Monthly aggregate · Frequency: Monthly · Aggregation: aggregate (month) · Staged: no · Main source: HRIS.

Field	Dataset	Type
`employee_id`	employee	string
`employee_status`	employee	string
`snapshot_date`	employee	date
`termination_date`	employee	date

Example SQL (Postgres)

SELECT (CAST((SELECT COUNT(DISTINCT employee_id) FROM employee WHERE snapshot_date = :period_end AND (termination_date >= :period_start AND termination_date <= :period_end)) AS DOUBLE PRECISION) / NULLIF((CAST((((SELECT COUNT(DISTINCT employee_id) FROM employee WHERE snapshot_date = :period_start AND employee_status = 'active')) + ((SELECT COUNT(DISTINCT employee_id) FROM employee WHERE snapshot_date = :period_end AND employee_status = 'active'))) AS DOUBLE PRECISION) / 2), 0)) AS employee_turnover

Access: recommended sensitivity tier restricted, access scope unscoped. Guidance your policy engine enforces.

From an agent: with the GASP MCP server, call lookup_metric({ "name": "Employee Turnover Rate" }) or generate_query({ "metric": "Employee Turnover Rate", "adapter": "<your adapter JSON>" }).

Benchmarks

Below 10%: Excellent retention
10-15%: Good
13-20%: Average for tech (tech runs higher than other industries)
20-25%: High for tech, investigate
Above 25%: Critical

Connected in the GASP relationship graph.

Upstream: what drives this

Employee NPS reduces Employee Turnover Rate (People)

Downstream: what this drives

Employee Turnover Rate reduces Revenue per Employee (Finance)
Employee Turnover Rate reduces Quota Attainment (Sales)
Employee Turnover Rate measures Employee (Entity)

Sources

← Back to People metrics