Diversity Representation: Percentage of workforce from underrepresented groups.
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.underrepresented_group = true and field.employee_status = 'active') / count_distinct(field.employee_id where field.employee_status = 'active') at period_endUnit: percent (the formula yields an unscaled ratio)
Notes: Track overall and by department or level.
Data requirements
Grain: End-of-month snapshot · Frequency: Monthly · Aggregation: snapshot (month) · Staged: no · Main source: HRIS.
| Field | Dataset | Type |
|---|---|---|
employee_id | employee | string |
employee_status | employee | string |
snapshot_date | employee | date |
underrepresented_group | employee | boolean |
Example SQL (Postgres)
SELECT (CAST((SELECT COUNT(DISTINCT employee_id) FROM employee WHERE snapshot_date = :period_end AND (underrepresented_group = TRUE AND employee_status = 'active')) AS DOUBLE PRECISION) / NULLIF((SELECT COUNT(DISTINCT employee_id) FROM employee WHERE snapshot_date = :period_end AND employee_status = 'active'), 0)) AS diversity_representation From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Diversity Representation" }) or generate_query({ "metric": "Diversity Representation", "adapter": "<your adapter JSON>" }).