Professional Services Delivery Metrics Operational

Project Milestone Completion Rate

Project Milestone Completion Rate: Percentage of milestones completed on schedule.

Formula

Project Milestone Completion Rate = Milestones on time / Total milestones × 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.project_milestone_id where in_period(field.actual_date) and field.actual_date <= field.planned_date) / count_distinct(field.project_milestone_id where in_period(field.actual_date))

Unit: percent (the formula yields an unscaled ratio)

Notes: Milestones delivered in the period that met their planned date.

Data requirements

Grain: Per event · Frequency: Per milestone · Aggregation: event · Staged: no · Main source: PSA.

Field	Dataset	Type
`actual_date`	project_milestone	date
`planned_date`	project_milestone	date
`project_milestone_id`	project_milestone	string
`snapshot_date`	project_milestone	date

Example SQL (Postgres)

SELECT (CAST((SELECT COUNT(DISTINCT project_milestone_id) FROM project_milestone WHERE snapshot_date = :period_end AND ((actual_date >= :period_start AND actual_date <= :period_end) AND actual_date <= planned_date)) AS DOUBLE PRECISION) / NULLIF((SELECT COUNT(DISTINCT project_milestone_id) FROM project_milestone WHERE snapshot_date = :period_end AND (actual_date >= :period_start AND actual_date <= :period_end)), 0)) AS project_milestone_completion_rate

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

← Back to Professional Services metrics