Average Tenure

Average Tenure: Average length of employment.

Formula

Average Tenure = Sum of employee tenure / Total employees

Computable definition

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

(avg(field.snapshot_date - field.hire_date where field.employee_status = 'active') at period_end) / 30.4375

Unit: months

Notes: Markdown allows months or years. Months is canonical.

Data requirements

Grain: End-of-month snapshot · Frequency: Monthly · Aggregation: snapshot (month) · Staged: no · Main source: HRIS.

Field	Dataset	Type
`employee_status`	employee	string
`hire_date`	employee	date
`snapshot_date`	employee	date

Example SQL (Postgres)

SELECT (CAST((SELECT AVG((snapshot_date - hire_date)) FROM employee WHERE snapshot_date = :period_end AND employee_status = 'active') AS DOUBLE PRECISION) / 30.4375) AS average_tenure

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

What It Tells You

Workforce stability and institutional knowledge.

← Back to People metrics