Ticket Backlog

Ticket Backlog: Number of tickets open or pending at the end of the period.

Formula

Backlog = Count of open tickets

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.ticket_id where field.ticket_status in ('open', 'pending')) at period_end

Unit: count

Data requirements

Grain: Open work items at period end · Frequency: Daily · Aggregation: snapshot (day) · Staged: no · Main source: Help Desk.

Field	Dataset	Type
`created_at`	ticket	timestamp
`ticket_id`	ticket	string
`ticket_status`	ticket	string

Example SQL (Postgres)

SELECT (SELECT COUNT(DISTINCT ticket_id) FROM ticket WHERE created_at < (:period_end + INTERVAL '1 day') AND ticket_status IN ('open', 'pending')) AS ticket_backlog

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

What It Tells You

Current support debt. It should hold steady or fall.

← Back to Support metrics