Skip to main content

Weekly Ticket Volume

Number of PSOM tickets in each Monday snapshot.

The total number of PSOM tickets captured in each Monday snapshot, showing how the number of tickets in the project changes over time.

Calculation

Keep only the Monday date partitions and count the rows in each. The snapshot ran weekly on Mondays until 2026-09-28 and nightly from 2026-09-29, so filtering to Mondays gives one comparable total per week across the whole history.

For a finer view from 2026-09-29 on, count every partition: there is one per night.

By week:

SELECT
    date,
    COUNT(*) AS ticket_count
FROM jira.psom
WHERE day_of_week(CAST(date AS DATE)) = 1
GROUP BY date
ORDER BY date DESC;

By day, from the first nightly snapshot:

SELECT
    date,
    COUNT(*) AS ticket_count
FROM jira.psom
WHERE CAST(date AS DATE) >= DATE '2026-09-29'
GROUP BY date
ORDER BY date DESC;

By week:

tbl(con, in_schema("jira", "psom")) |>
  filter(wday(as.Date(date), week_start = 1) == 1) |>
  count(date, name = "ticket_count") |>
  arrange(desc(date))

By day, from the first nightly snapshot:

tbl(con, in_schema("jira", "psom")) |>
  filter(as.Date(date) >= as.Date("2026-09-29")) |>
  count(date, name = "ticket_count") |>
  arrange(desc(date))

Interpretation notes

This counts the tickets still in the project on each Monday, not the tickets opened that week or the open backlog; for those, see Tickets Opened, Closed, and Open. It includes Done and Canceled tickets until they are archived, and it drops when a batch of tickets is archived (from 52 to 25 between 2026-09-14 and 2026-09-21). The first snapshot, 2026-06-30, was a Tuesday, so the filter leaves it out.

Alternative names

  • total tickets per week
  • weekly PSOM ticket count
  • ticket volume trend