Web Ticket Dashboard - Web Tools

Tickets closed, pace against target, and current workload for the Metro Web Team.

Follow the steps below:

The dashboard loads data/ticket_export.csv automatically when it is available.
Or upload a CSV file yourself.
The dates start on the current fiscal year (September 1 – August 31). Change the Start Date and End Date to look at a different range. This affects Closed Tickets and Work Analysis.
Set the Annual Target for tickets per developer. It is used to measure pace.
Click Update Dashboard to refresh every tab with your dates and target.
All numbers are as of the date the ticket data was updated, and include only tickets assigned to Mark, Melissa, Trang, and Adrian.
Use the tabs to switch between different views:
- Closed Tickets - Tickets closed, pace against target, and monthly totals
- Current Workload - New and closed tickets, how long tickets have been open, and the list of open tickets
- Work Analysis - Level of Effort and Web Work Type for tickets closed in the selected dates, or for open tickets

Upload CSV File (optional):

Start Date:

End Date:

Annual Target per Developer: Target number of tickets each developer should close per year.

Loading CSV file from data folder…

Completed Work Summary

Tickets missing a Level of Effort or Web Work Type

Closed Tickets by Developer

Individual Target: 100 tickets/year (1.9/week, 8.3/month)

Closed tickets by developer, with pace against the individual target
Developer	Closed Tickets	Expected to Date	Ahead / Behind	Weekly Average	Monthly Average

Ticket Lifecycle

These are calendar days, not hours worked. Waiting on content, approvals, or a launch date can add days to a ticket.

Current Workload Summary

Tickets missing a Level of Effort or Web Work Type

High Priority

Medium Priority

Low Priority

Workload by Developer

Open tickets by developer and priority
Developer	Open Tickets	High Priority	Medium Priority	Low Priority

Ticket Activity

Weekly incoming and completed tickets.

New tickets · 30 days

—

Closed tickets · 30 days

—

Net change · 30 days

—

Weekly New vs. Closed Tickets (Last 8 Weeks)

Ticket Age

These are calendar days, not hours worked. Waiting on content, approvals, or a launch date can add days to a ticket.

Open Tickets Detail

Filter by Developer:

Filter by Priority:

Filter by Level of Effort:

Filter by Web Work Type:

Open tickets. Select a column heading to sort.
								Summary

Web Ticket Dashboard v3.1.6

Performance Period: Sep 1, 2026 - Aug 31, 2027