Build a live threshold board: agents bucketed by time on an Open ticket
When a vendor or team lead asks "which of my agents has been sitting on a ticket for more than twenty minutes right now?", a single average will not answer it. What answers it is a row of live counts — one per time bucket — that you can click into to see exactly who is in each one.
Qvasa builds that with one quick stat metric and its two minute thresholds. Add the same metric several times with different thresholds and you get a live threshold board: Under 5 min, 5 – 10 min, 10 – 20 min, 20+ min. Each number is a count of agents, and each one drills in to the agents behind it.
This guide covers finding the metric, setting the thresholds, building the board, and using the Agents drill-in.
Before you start
You need permission to edit the dashboard you are adding widgets to.
The metric comes in three channel variants — Email, Messaging and Talk. You need the matching channel connected. The examples below use Email.
This tracking began on 2 September 2026. A ticket that has had no activity at all since before that date is not counted yet; it joins the moment anything happens on it — a reply, a status change, a reassignment.
Step 1 — Find the metric
Open your dashboard, click Edit, then add a widget. In the widget picker choose the Quick stat widget type and search for agents with open assignments.
Three results appear, one per channel, under Ticket Assignment Metrics:
Email channel agents with open assignments live
Messaging channel agents with open assignments live
Talk channel agents with open assignments live
Pick the one for your channel. In this guide that is the Email variant.
Step 2 — Set the two thresholds
Selecting the metric opens its configuration on the right. Below the chart type and size you will find the two fields that turn a plain count into a bucket:
Field | What it does |
Longest open email assignment at least X (mins) | The floor. Keeps agents whose longest open assignment has been running for X minutes or more. |
Longest open email assignment under X (mins) | The ceiling. Keeps agents below X minutes. This end is exclusive, so an agent at exactly X falls into the next bucket up, never into two at once. |
Leave either field at 0 to switch it off. That is what makes open-ended buckets possible:
0 and 5 — everyone under five minutes.
5 and 10 — the five-to-ten band.
20 and 0 — everyone at twenty minutes and above, with no upper limit.
0 and 0 — no bucketing at all: every agent currently holding an Open ticket on that channel.
Both fields accept 0 to 43,200 minutes (30 days). Set the chart type to Single Number and give the widget a name that matches its bucket, then add it.
Step 3 — Repeat for each bucket
Add the same metric once per band, changing only the two thresholds and the widget name. Four small quick stats in one row give you the whole picture at a glance:
Because the ceiling is exclusive and the floor is inclusive, adjacent buckets never double-count: the four numbers above add up to the total number of agents holding an Open email ticket right now.
Every dashboard filter still applies before the bucketing, so an agent-group or email-domain filter gives you one board per vendor or team — which is the usual reason to build this.
Step 4 — Inspect the agents behind a number
A count on its own tells you there is a problem; the drill-in tells you who to talk to. Open the widget's actions menu and choose the Agents drill-in:
The list contains exactly the agents the number counted — no re-filtering, no discrepancy between the badge and the list. Use CSV to export it.
There is a second drill-in on the same menu: Tickets. It returns one ticket per counted agent — the single longest-running Open ticket that put them in this bucket — so you can open the actual conversation in Zendesk or in Qvasa.
How the clock works
Three details decide which bucket an agent lands in.
The clock starts when the agent was assigned, not when the ticket entered the Open status. If a ticket sat in Open for an hour before anyone picked it up, the agent's clock still starts at the moment of assignment. It stops the moment the ticket leaves Open or the agent is unassigned.
Each agent is represented by one assignment — their longest-running one. The metric counts distinct agents, not tickets. An agent holding four Open tickets appears once, placed by their oldest of the four. That is why the buckets can be read as "how many people", not "how much work".
The date range does not apply. This is a live snapshot of this moment, so the dashboard's date filter does not limit which assignments count. A ticket picked up days ago still counts while it stays Open and assigned — which is exactly what you want from a board designed to surface the ticket nobody has touched. For the same reason the metric cannot time-travel: selecting a past date will not rebuild who was holding what last Tuesday.
Is this the metric you want?
Two nearby metrics answer similar-sounding but different questions.
To measure how long the ticket has been in Open rather than how long the agent has held it, use Email Longest Time in Open Status (Live). The two differ whenever a ticket entered Open before it was assigned.
To see per-agent durations in a table instead of counts in buckets, use the by-agent live columns described in Open-status metrics on ticket assignment sessions.
To review what already happened rather than what is happening now, use the historical assignment-session metrics in that same guide.
Troubleshooting
The metric is not in the widget picker. Confirm you are on the Quick stat widget type — it is not available as a chart — and that the channel it needs is connected. The Email variant requires an Email channel, and so on.
Every bucket reads 0. Check the thresholds first: a floor above a ceiling (for example "at least 20" with "under 10") describes an impossible band and will always be empty. Then confirm agents really are holding Open tickets on that channel right now — set both fields to 0 to see the unbucketed total.
The total is lower than you expect. Tickets with no activity since 2 September 2026 have not joined the metric yet. They appear as soon as anything happens on them.
An agent appears in a bucket you did not expect. Remember they are placed by their longest open assignment. An agent who picked up three tickets in the last minute but still holds one from half an hour ago sits in the 20+ bucket.
Related




