Tickets by Priority
PSOM tickets in the latest snapshot, by priority.
The number of PSOM tickets in the latest snapshot grouped by priority level.
Calculation
Filter to the most recent date partition and count tickets by priority.
NoteExample queries
SELECT
priority,
COUNT(*) AS ticket_count
FROM jira.psom
WHERE date = (SELECT MAX(date) FROM jira.psom)
GROUP BY priority
ORDER BY ticket_count DESC;psom <- tbl(con, in_schema("jira", "psom"))
latest_date <- psom |> summarise(d = max(date, na.rm = TRUE)) |> pull(d)
psom |>
filter(as.Date(date) == as.Date(latest_date)) |>
count(priority, name = "ticket_count") |>
arrange(desc(ticket_count))Alternative names
- ticket priority breakdown
- PSOM tickets by priority
- priority distribution