Skip to main content

Jira (PSOM)

Metrics in this section are calculated from PSOM Jira Service Management ticket data.

The relevant Jira tables are:

Data cadence. The tables are updated once per day (at ~06:00 ET); before 2026-09-29 they were updated weekly, on Mondays. Each run writes a full snapshot of all tickets currently in the project to a new date= partition; previous partitions are preserved as an audit trail. Always filter to date = (SELECT MAX(date) FROM <table>) when querying the latest state. Join the tables on key and date.

PSOM Metrics

Metric Description
Tickets by Status PSOM tickets in the latest snapshot, by workflow status.
Weekly Ticket Volume Number of PSOM tickets in each Monday snapshot.
Tickets Opened, Closed, and Open PSOM tickets opened and closed each week, the queue at the end of it, and how long tickets stay open.
Tickets by Priority PSOM tickets in the latest snapshot, by priority.
SLA First-Response Breach Rate Share of PSOM tickets that missed the time-to-first-response SLA.
SLA Time-to-Done Breach Rate Share of PSOM tickets that missed the time-to-done SLA.
SLA PSO Time-to-Done Breach Rate Share of PSOM tickets that missed the PSO time-to-done SLA.
No matching items