We ran our Process X-ray on 4,580 real support tickets (21,348 logged steps, 2010–2014) from the IT help desk of an Italian software company. We turned the log into a process graph and a handover network between 22 staff accounts. Here's where the time goes, and what we'd fix first.
39.9 days
Median time from ticket opened to closed
6.0 days
Median time until the issue is actually fixed
29.9 days
Fix time for the slowest 10% of tickets
226
Different paths through what is meant to be a 4-step process
Exhibit 1 · The process as it really runs
The process map, rebuilt from the log
Each box is a step; each arrow is a hand-off from one step to the next. Only 52% of tickets follow the textbook path (assign → take in charge → resolve → close). Hover any arrow for its numbers.
Normal transitionSlow transition: median wait 5 days or moreLine width = number of tickets · label = tickets · median wait
Exhibit 2 · Where the time goes
72% of all ticket time is a waiting window after the fix
After a ticket is resolved, it stays open for a fixed confirmation window before it closes. That window was about 30 days until 2012; the data shows it dropped to 15 days in 2013. It isn't work, but it makes "time to close" look more than six times longer than "time to fix" in every report.
Share of all elapsed ticket time, by what the ticket was waiting for4,580 tickets
Exhibit 3 · The real problem is the long tail
36% of tickets take more than two weeks to fix, and they hold 82% of all fix-days
Most tickets are fast: 29% are fixed within a day. The average fix time (11.1 days) is dragged up by a minority that gets stuck. Those are the ones customers remember.
Days from ticket opened to first fixUnder 14 days14 days or more
Exhibit 4 · What makes a ticket slow
Three patterns separate fast tickets from stuck ones
Median days to fix, comparing tickets with and without each pattern. These are associations in the data, not proof of cause, but they show where to look first.
Waiting to be picked up
Median pickup is 6 hours, but 29% of tickets wait over 3 days, and those hold 92% of all queue time.
Parked in "Wait" status
27% of tickets get parked. They take 18.9 days to fix against 2.8 for the rest.
Passed between people
Every handover before the fix multiplies the time. Tickets solved by the first person take 1 day.
Also: the 3% of tickets escalated to development (upgrade or software bug) take 26.2 days, against 5.7 for the rest.
Exhibit 5 · The handover network
One person sits in the middle of everything
This is the social graph of the help desk: who passes tickets to whom. Agent 2 handles 20% of all steps, is involved in 49% of the handovers between agents, and sits on 2.3× more of the shortest paths in the network than anyone else (betweenness centrality). That is a bottleneck in busy weeks and a risk when Agent 2 is away.
Most central personAgent (size = steps handled)Closing desk (automatic closing accounts)Arrow width = number of handovers
What we'd do
Five changes, in order of effort
Estimates come straight from the log and assume the team has the capacity to make the change; a pilot would test them.
1. Measure time-to-fix, not time-to-close
Report the fix date as the headline KPI and shorten the confirmation window to 7 days, with one-click reopening for customers.
Median time-to-close on paper: 39.9 → 13.7 days, with no change in the work.
2. A one-working-day pickup rule
Flag every ticket not taken in charge within one working day, and give someone ownership of the queue each day.
Average fix time: 11.1 → ~8.2 days if no ticket waited more than a day for pickup.
3. Give "Wait" a reason and a deadline
Require a reason code when parking a ticket, and sweep every parked ticket weekly. 27% of tickets pass through this status today.
Targets the group that takes 18.9 days to fix instead of 2.8.
4. Route tickets right the first time
Use the ticket's product, customer and description to suggest the right agent at intake. This is where an AI classifier pays off.
Fewer handovers: tickets solved by the first agent take 1 day, not 6–18.
5. Reduce the dependency on one person
Cross-train two agents on the ticket types that only Agent 2 handles today, and route those types to them first.
Less queueing in peak weeks, and no single point of failure.
Read this with care
Limits of this demo
The data is public and anonymised, so people, products and customers appear as codes, and it covers 2010–2014.
The comparisons in Exhibit 4 show association, not cause. Hard tickets may be parked or handed over because they're hard.
We only see the logged steps, not the ticket text. With a real client we'd add their categories, SLAs and costs per hour.
How a Process X-ray works
Two weeks, one export, a clear answer
Step 1 · Day 1
You export a log
Four columns from your ERP, ticketing or order system: case ID, step, timestamp, person or team. No system access needed.
Step 2 · Days 2–8
We rebuild the process
Process map, waiting times, rework loops, handover network and the paths that cost the most.
Step 3 · Days 9–10
You get the X-ray
A report like this one on your own data, the top fixes with estimated impact, and a walkthrough with your team.
GoldenDane · Applied AI for operations teams
Want to see this on your own process?
Orders, invoices, service tickets, quality deviations: if a system logs it, we can X-ray it. Send us a note and we'll tell you within a day what an export would need to contain.
Data: the public research dataset "Dataset belonging to the help desk log of an Italian Company" by Mirko Polato (2017), published on 4TU.ResearchData under the 4TU General Terms of Use. Analysis and graphs by GoldenDane ApS with Python, pandas, NetworkX and Graphviz. Staff accounts are anonymised in the source data; "Agent" numbers follow the dataset's own codes.