Skip to main content

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.

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