Analysis of 42,624 tickets across the last 12 months, separating first-time issues from repeat problems.
Analysis of 42,624 tickets across the last 12 months, separating first-time issues from repeat problems.
The data covers the full scope of Autotask PSA records relevant to this analysis, broken down by the key dimensions your team needs for day-to-day decisions and client reporting.
Who should use this: Service desk managers, dispatch leads, and operations teams
How often: Daily for queue management, weekly for trend analysis, monthly for capacity planning
Analysis of 42,624 tickets across the last 12 months, separating first-time issues from repeat problems.
High-level split between new and recurring tickets.
EVALUATE ROW("Total", COUNTROWS('BI_Autotask_Tickets'), "Companies", DISTINCTCOUNT('BI_Autotask_Tickets'[company_id]), "AvgPerCompany", DIVIDE(COUNTROWS('BI_Autotask_Tickets'), DISTINCTCOUNT('BI_Autotask_Tickets'[company_id])))
Top 10 clients by ticket volume, with their recurring ticket percentage. A high recurring ratio at a single account often signals an unresolved infrastructure issue or a gap in documentation.
| Client | Total | New | Recurring | Recurring % |
|---|---|---|---|---|
| Lambert Telecom | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Turner Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Olsen Data Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Franklin Services | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Quinn Resorts | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Turner Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Sullivan & Co | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Turner Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Harrison Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Quinn Resorts | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Olsen Data Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Grant Technologies | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Anderson Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Lambert Telecom | 42,624 | 3,889 | 38,735 | 90.9% |
| Sullivan & Co | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Quinn Resorts | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Irving Solutions | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Roberts Inc | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Lambert Telecom | 42,624 | 3,889 | 38,735 | 90.9% |
| Anderson Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Roberts Inc | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Quinn Resorts | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Harrison Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Lambert Telecom | 42,624 | 3,889 | 38,735 | 90.9% |
| Franklin Services | 42,624 | 3,889 | 38,735 | 90.9% |
| Olsen Data Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Anderson Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Franklin Services | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Lambert Telecom | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Anderson Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Quinn Resorts | 42,624 | 3,889 | 38,735 | 90.9% |
| Roberts Inc | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Grant Technologies | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Turner Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Quinn Resorts | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Anderson Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Irving Solutions | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Roberts Inc | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Olsen Data Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Quinn Resorts | 42,624 | 3,889 | 38,735 | 90.9% |
| Harrison Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Irving Solutions | 42,624 | 3,889 | 38,735 | 90.9% |
| Quinn Resorts | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Anderson Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Sullivan & Co | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Olsen Data Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Olsen Data Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Grant Technologies | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Lambert Telecom | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Franklin Services | 42,624 | 3,889 | 38,735 | 90.9% |
| Lambert Telecom | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Olsen Data Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Irving Solutions | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Grant Technologies | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Anderson Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Roberts Inc | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Quinn Resorts | 42,624 | 3,889 | 38,735 | 90.9% |
| Sullivan & Co | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Grant Technologies | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Harrison Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Quinn Resorts | 42,624 | 3,889 | 38,735 | 90.9% |
| Sullivan & Co | 42,624 | 3,889 | 38,735 | 90.9% |
| Roberts Inc | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Turner Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Olsen Data Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Harrison Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Roberts Inc | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Harrison Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Franklin Services | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Turner Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Grant Technologies | 42,624 | 3,889 | 38,735 | 90.9% |
| Anderson Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Anderson Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Irving Solutions | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Lambert Telecom | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Franklin Services | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Turner Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Irving Solutions | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Ellis Manufacturing | 42,624 | 3,889 | 38,735 | 90.9% |
| Mitchell Global | 42,624 | 3,889 | 38,735 | 90.9% |
| Anderson Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Roberts Inc | 42,624 | 3,889 | 38,735 | 90.9% |
| Bradley & Sons | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Franklin Services | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Turner Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Olsen Data Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Anderson Corp | 42,624 | 3,889 | 38,735 | 90.9% |
| Palmer Estates | 42,624 | 3,889 | 38,735 | 90.9% |
| Franklin Services | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Harrison Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Roberts Inc | 42,624 | 3,889 | 38,735 | 90.9% |
| Harrison Group | 42,624 | 3,889 | 38,735 | 90.9% |
| Franklin Services | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Sullivan & Co | 42,624 | 3,889 | 38,735 | 90.9% |
| Jackson Logistics | 42,624 | 3,889 | 38,735 | 90.9% |
| Nelson Publishing | 42,624 | 3,889 | 38,735 | 90.9% |
| Davidson Financial | 42,624 | 3,889 | 38,735 | 90.9% |
| Irving Solutions | 42,624 | 3,889 | 38,735 | 90.9% |
| Quinn Resorts | 42,624 | 3,889 | 38,735 | 90.9% |
| Kennedy Creative | 42,624 | 3,889 | 38,735 | 90.9% |
| Carter Industries | 42,624 | 3,889 | 38,735 | 90.9% |
| Roberts Inc | 42,624 | 3,889 | 38,735 | 90.9% |
EVALUATE
VAR TicketsWithSeq =
ADDCOLUMNS(
FILTER(
'BI_Autotask_Tickets',
'BI_Autotask_Tickets'[create_date] >= DATE(2025, 3, 1) &&
'BI_Autotask_Tickets'[create_date] < DATE(2026, 3, 1)
),
"IsRecurring",
IF(
COUNTROWS(
FILTER(
'BI_Autotask_Tickets',
'BI_Autotask_Tickets'[company_name] = EARLIER('BI_Autotask_Tickets'[company_name]) &&
'BI_Autotask_Tickets'[issue_type_name] = EARLIER('BI_Autotask_Tickets'[issue_type_name]) &&
'BI_Autotask_Tickets'[sub_issue_type_name] = EARLIER('BI_Autotask_Tickets'[sub_issue_type_name]) &&
'BI_Autotask_Tickets'[create_date] < EARLIER('BI_Autotask_Tickets'[create_date])
)
) > 0,
1, 0
)
)
RETURN
TOPN(
10,
ADDCOLUMNS(
SUMMARIZE(TicketsWithSeq, 'BI_Autotask_Tickets'[company_name]),
"Total", CALCULATE(COUNTROWS(TicketsWithSeq)),
"Recurring", CALCULATE(COUNTROWS(FILTER(TicketsWithSeq, [IsRecurring] = 1))),
"RecurPct", DIVIDE(
CALCULATE(COUNTROWS(FILTER(TicketsWithSeq, [IsRecurring] = 1))),
CALCULATE(COUNTROWS(TicketsWithSeq))
) * 100
),
[Total], DESC
)
ORDER BY [Total] DESC
Which issue categories generate the most repeat tickets? Categories with a high recurring percentage are candidates for root-cause analysis or proactive remediation.
| Issue Type | Total | Recurring | Recurring % |
|---|---|---|---|
| Financial risk analyst | 42,624 | 38,735 | 90.9% |
| Secretary, company | 42,624 | 38,735 | 90.9% |
| 42,624 | 38,735 | 90.9% | |
| Trade union research officer | 42,624 | 38,735 | 90.9% |
| Radio broadcast assistant | 42,624 | 38,735 | 90.9% |
| Environmental health practitioner | 42,624 | 38,735 | 90.9% |
| Exhibitions officer, museum/gallery | 42,624 | 38,735 | 90.9% |
| Data processing manager | 42,624 | 38,735 | 90.9% |
| Designer, interior/spatial | 42,624 | 38,735 | 90.9% |
| Teacher, music | 42,624 | 38,735 | 90.9% |
| Retail buyer | 42,624 | 38,735 | 90.9% |
| Chartered certified accountant | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | 42,624 | 38,735 | 90.9% |
| Solicitor, Scotland | 42,624 | 38,735 | 90.9% |
| General practice doctor | 42,624 | 38,735 | 90.9% |
| Airline pilot | 42,624 | 38,735 | 90.9% |
| Commercial horticulturist | 42,624 | 38,735 | 90.9% |
| Nurse, learning disability | 42,624 | 38,735 | 90.9% |
| Public librarian | 42,624 | 38,735 | 90.9% |
| Designer, ceramics/pottery | 42,624 | 38,735 | 90.9% |
| Education officer, community | 42,624 | 38,735 | 90.9% |
| Health and safety inspector | 42,624 | 38,735 | 90.9% |
| Risk analyst | 42,624 | 38,735 | 90.9% |
| Chief Financial Officer | 42,624 | 38,735 | 90.9% |
| Barrister | 42,624 | 38,735 | 90.9% |
| Haematologist | 42,624 | 38,735 | 90.9% |
| Prison officer | 42,624 | 38,735 | 90.9% |
| Tax adviser | 42,624 | 38,735 | 90.9% |
| Outdoor activities/education manager | 42,624 | 38,735 | 90.9% |
| Journalist, newspaper | 42,624 | 38,735 | 90.9% |
| Land/geomatics surveyor | 42,624 | 38,735 | 90.9% |
| Private music teacher | 42,624 | 38,735 | 90.9% |
| Engineer, civil (contracting) | 42,624 | 38,735 | 90.9% |
| Pension scheme manager | 42,624 | 38,735 | 90.9% |
| Technical sales engineer | 42,624 | 38,735 | 90.9% |
| Land | 42,624 | 38,735 | 90.9% |
| Interior and spatial designer | 42,624 | 38,735 | 90.9% |
| Town planner | 42,624 | 38,735 | 90.9% |
EVALUATE
VAR TicketsWithSeq =
ADDCOLUMNS(
FILTER(
'BI_Autotask_Tickets',
'BI_Autotask_Tickets'[create_date] >= DATE(2025, 3, 1) &&
'BI_Autotask_Tickets'[create_date] < DATE(2026, 3, 1)
),
"IsRecurring",
IF(
COUNTROWS(
FILTER(
'BI_Autotask_Tickets',
'BI_Autotask_Tickets'[company_name] = EARLIER('BI_Autotask_Tickets'[company_name]) &&
'BI_Autotask_Tickets'[issue_type_name] = EARLIER('BI_Autotask_Tickets'[issue_type_name]) &&
'BI_Autotask_Tickets'[sub_issue_type_name] = EARLIER('BI_Autotask_Tickets'[sub_issue_type_name]) &&
'BI_Autotask_Tickets'[create_date] < EARLIER('BI_Autotask_Tickets'[create_date])
)
) > 0,
1, 0
)
)
RETURN
TOPN(
8,
ADDCOLUMNS(
SUMMARIZE(TicketsWithSeq, 'BI_Autotask_Tickets'[issue_type_name]),
"Total", CALCULATE(COUNTROWS(TicketsWithSeq)),
"Recurring", CALCULATE(COUNTROWS(FILTER(TicketsWithSeq, [IsRecurring] = 1))),
"RecurPct", DIVIDE(
CALCULATE(COUNTROWS(FILTER(TicketsWithSeq, [IsRecurring] = 1))),
CALCULATE(COUNTROWS(TicketsWithSeq))
) * 100
),
[Recurring], DESC
)
ORDER BY [Recurring] DESC
How the new-vs-recurring split changes over time. A rising recurring percentage means root causes are not being addressed. A falling one means your fixes are sticking.
| Month | Total | New | Recurring | Recurring % |
|---|---|---|---|---|
| Mar 2025 | 42,624 | 3,889 | 38,735 | 90.9% |
| Apr 2025 | 42,624 | 3,889 | 38,735 | 90.9% |
| May 2025 | 42,624 | 3,889 | 38,735 | 90.9% |
| Jun 2025 | 42,624 | 3,889 | 38,735 | 90.9% |
| Jul 2025 | 42,624 | 3,889 | 38,735 | 90.9% |
| Aug 2025 | 42,624 | 3,889 | 38,735 | 90.9% |
| Sep 2025 | 42,624 | 3,889 | 38,735 | 90.9% |
| Oct 2025 | 42,624 | 3,889 | 38,735 | 90.9% |
| Nov 2025 | 42,624 | 3,889 | 38,735 | 90.9% |
| Dec 2025 | 42,624 | 3,889 | 38,735 | 90.9% |
| Jan 2026 | 42,624 | 3,889 | 38,735 | 90.9% |
Drilling one level deeper into issue types. These are the specific sub-categories where the same company keeps logging tickets.
| Issue Type | Sub-Issue | Total | Recurring | Recurring % |
|---|---|---|---|---|
| Engineer, civil (contracting) | IT technical support officer | 42,624 | 38,735 | 90.9% |
| Designer, ceramics/pottery | Broadcast journalist | 42,624 | 38,735 | 90.9% |
| Secretary, company | Secretary, company | 42,624 | 38,735 | 90.9% |
| 42,624 | 38,735 | 90.9% | ||
| Designer, ceramics/pottery | Government social research officer | 42,624 | 38,735 | 90.9% |
| Trade union research officer | Pilot, airline | 42,624 | 38,735 | 90.9% |
| Radio broadcast assistant | Designer, textile | 42,624 | 38,735 | 90.9% |
| Environmental health practitioner | Clinical biochemist | 42,624 | 38,735 | 90.9% |
| Environmental health practitioner | Banker | 42,624 | 38,735 | 90.9% |
| Exhibitions officer, museum/gallery | Exhibitions officer, museum/gallery | 42,624 | 38,735 | 90.9% |
| Data processing manager | Environmental health practitioner | 42,624 | 38,735 | 90.9% |
| Designer, interior/spatial | Community education officer | 42,624 | 38,735 | 90.9% |
| Trade union research officer | Secretary/administrator | 42,624 | 38,735 | 90.9% |
| Teacher, music | General practice doctor | 42,624 | 38,735 | 90.9% |
| Retail buyer | Retail buyer | 42,624 | 38,735 | 90.9% |
| Chartered certified accountant | 42,624 | 38,735 | 90.9% | |
| Teacher, music | 42,624 | 38,735 | 90.9% | |
| Designer, interior/spatial | Designer, interior/spatial | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Chemist, analytical | 42,624 | 38,735 | 90.9% |
| Solicitor, Scotland | Interior and spatial designer | 42,624 | 38,735 | 90.9% |
| General practice doctor | Designer, textile | 42,624 | 38,735 | 90.9% |
| Airline pilot | Airline pilot | 42,624 | 38,735 | 90.9% |
| Commercial horticulturist | Public librarian | 42,624 | 38,735 | 90.9% |
| Radio broadcast assistant | Trade union research officer | 42,624 | 38,735 | 90.9% |
| Nurse, learning disability | Therapist, horticultural | 42,624 | 38,735 | 90.9% |
| Public librarian | Scientist, biomedical | 42,624 | 38,735 | 90.9% |
| Financial risk analyst | Interior and spatial designer | 42,624 | 38,735 | 90.9% |
| Education officer, community | Furniture conservator/restorer | 42,624 | 38,735 | 90.9% |
| Financial risk analyst | Private music teacher | 42,624 | 38,735 | 90.9% |
| Education officer, community | Cartographer | 42,624 | 38,735 | 90.9% |
| Nurse, learning disability | IT technical support officer | 42,624 | 38,735 | 90.9% |
| Education officer, community | Biomedical engineer | 42,624 | 38,735 | 90.9% |
| Nurse, learning disability | Surveyor, land/geomatics | 42,624 | 38,735 | 90.9% |
| Financial risk analyst | Chief Financial Officer | 42,624 | 38,735 | 90.9% |
| Teacher, music | Social researcher | 42,624 | 38,735 | 90.9% |
| Financial risk analyst | Recycling officer | 42,624 | 38,735 | 90.9% |
| Health and safety inspector | Risk analyst | 42,624 | 38,735 | 90.9% |
| Designer, ceramics/pottery | Financial risk analyst | 42,624 | 38,735 | 90.9% |
| Risk analyst | Translator | 42,624 | 38,735 | 90.9% |
| Chief Financial Officer | Chief Financial Officer | 42,624 | 38,735 | 90.9% |
| Designer, ceramics/pottery | Visual merchandiser | 42,624 | 38,735 | 90.9% |
| Radio broadcast assistant | Geochemist | 42,624 | 38,735 | 90.9% |
| Chartered certified accountant | Education officer, community | 42,624 | 38,735 | 90.9% |
| General practice doctor | Chartered public finance accountant | 42,624 | 38,735 | 90.9% |
| Financial risk analyst | Scientist, biomedical | 42,624 | 38,735 | 90.9% |
| Education officer, community | Therapist, horticultural | 42,624 | 38,735 | 90.9% |
| Financial risk analyst | Education officer, community | 42,624 | 38,735 | 90.9% |
| Education officer, community | Advertising account planner | 42,624 | 38,735 | 90.9% |
| Risk analyst | Environmental health practitioner | 42,624 | 38,735 | 90.9% |
| Chartered certified accountant | Teacher, music | 42,624 | 38,735 | 90.9% |
| Barrister | Journalist, newspaper | 42,624 | 38,735 | 90.9% |
| Haematologist | Retail merchandiser | 42,624 | 38,735 | 90.9% |
| Public librarian | Special effects artist | 42,624 | 38,735 | 90.9% |
| Haematologist | Museum/gallery curator | 42,624 | 38,735 | 90.9% |
| Chartered certified accountant | Engineer, civil (contracting) | 42,624 | 38,735 | 90.9% |
| Risk analyst | Television production assistant | 42,624 | 38,735 | 90.9% |
| General practice doctor | Adult nurse | 42,624 | 38,735 | 90.9% |
| Public librarian | IT sales professional | 42,624 | 38,735 | 90.9% |
| Environmental health practitioner | Early years teacher | 42,624 | 38,735 | 90.9% |
| Nurse, learning disability | Advertising account planner | 42,624 | 38,735 | 90.9% |
| Public librarian | Accountant, chartered certified | 42,624 | 38,735 | 90.9% |
| Teacher, music | Architectural technologist | 42,624 | 38,735 | 90.9% |
| Prison officer | Risk analyst | 42,624 | 38,735 | 90.9% |
| Teacher, music | Retail merchandiser | 42,624 | 38,735 | 90.9% |
| Tax adviser | Petroleum engineer | 42,624 | 38,735 | 90.9% |
| Nurse, learning disability | Furniture conservator/restorer | 42,624 | 38,735 | 90.9% |
| Haematologist | Sports development officer | 42,624 | 38,735 | 90.9% |
| Haematologist | Politician's assistant | 42,624 | 38,735 | 90.9% |
| Outdoor activities/education manager | Public relations account executive | 42,624 | 38,735 | 90.9% |
| Tax adviser | Barista | 42,624 | 38,735 | 90.9% |
| Financial risk analyst | Chief Executive Officer | 42,624 | 38,735 | 90.9% |
| Journalist, newspaper | Animal nutritionist | 42,624 | 38,735 | 90.9% |
| Financial risk analyst | Counsellor | 42,624 | 38,735 | 90.9% |
| Public librarian | Environmental consultant | 42,624 | 38,735 | 90.9% |
| Education officer, community | Engineer, production | 42,624 | 38,735 | 90.9% |
| Environmental health practitioner | Designer, exhibition/display | 42,624 | 38,735 | 90.9% |
| Public librarian | Surveyor, commercial/residential | 42,624 | 38,735 | 90.9% |
| Land/geomatics surveyor | Arboriculturist | 42,624 | 38,735 | 90.9% |
| Private music teacher | Chartered accountant | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Financial risk analyst | 42,624 | 38,735 | 90.9% |
| Designer, ceramics/pottery | General practice doctor | 42,624 | 38,735 | 90.9% |
| Risk analyst | Nurse, learning disability | 42,624 | 38,735 | 90.9% |
| Pension scheme manager | Television/film/video producer | 42,624 | 38,735 | 90.9% |
| Public librarian | Hospital pharmacist | 42,624 | 38,735 | 90.9% |
| Technical sales engineer | Pharmacologist | 42,624 | 38,735 | 90.9% |
| Risk analyst | Doctor, hospital | 42,624 | 38,735 | 90.9% |
| Environmental health practitioner | Microbiologist | 42,624 | 38,735 | 90.9% |
| Pension scheme manager | Higher education lecturer | 42,624 | 38,735 | 90.9% |
| Technical sales engineer | Telecommunications researcher | 42,624 | 38,735 | 90.9% |
| Technical sales engineer | Designer, interior/spatial | 42,624 | 38,735 | 90.9% |
| Land | Fast food restaurant manager | 42,624 | 38,735 | 90.9% |
| Tax adviser | Chief Operating Officer | 42,624 | 38,735 | 90.9% |
| Pension scheme manager | Sports coach | 42,624 | 38,735 | 90.9% |
| Land | Radiographer, therapeutic | 42,624 | 38,735 | 90.9% |
| Risk analyst | Social worker | 42,624 | 38,735 | 90.9% |
| Land | Sports development officer | 42,624 | 38,735 | 90.9% |
| Journalist, newspaper | Therapist, speech and language | 42,624 | 38,735 | 90.9% |
| Trade union research officer | Private music teacher | 42,624 | 38,735 | 90.9% |
| Pension scheme manager | Therapist, speech and language | 42,624 | 38,735 | 90.9% |
| Chief Financial Officer | Producer, radio | 42,624 | 38,735 | 90.9% |
| Private music teacher | Mudlogger | 42,624 | 38,735 | 90.9% |
| Education officer, community | Insurance claims handler | 42,624 | 38,735 | 90.9% |
| Education officer, community | Television production assistant | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Tax adviser | 42,624 | 38,735 | 90.9% |
| Engineer, civil (contracting) | Furniture conservator/restorer | 42,624 | 38,735 | 90.9% |
| Engineer, civil (contracting) | Microbiologist | 42,624 | 38,735 | 90.9% |
| Chief Financial Officer | Advertising account planner | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Licensed conveyancer | 42,624 | 38,735 | 90.9% |
| Technical sales engineer | Forensic psychologist | 42,624 | 38,735 | 90.9% |
| Risk analyst | Company secretary | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Librarian, public | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Surveyor, building control | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Commercial/residential surveyor | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Administrator, charities/voluntary organisations | 42,624 | 38,735 | 90.9% |
| Interior and spatial designer | Forest/woodland manager | 42,624 | 38,735 | 90.9% |
| Education officer, community | Farm manager | 42,624 | 38,735 | 90.9% |
| Chief Financial Officer | Furniture conservator/restorer | 42,624 | 38,735 | 90.9% |
| Education officer, community | Lecturer, further education | 42,624 | 38,735 | 90.9% |
| Interior and spatial designer | Dealer | 42,624 | 38,735 | 90.9% |
| General practice doctor | Educational psychologist | 42,624 | 38,735 | 90.9% |
| General practice doctor | Sport and exercise psychologist | 42,624 | 38,735 | 90.9% |
| General practice doctor | Teacher, secondary school | 42,624 | 38,735 | 90.9% |
| Land/geomatics surveyor | Horticultural consultant | 42,624 | 38,735 | 90.9% |
| General practice doctor | Insurance risk surveyor | 42,624 | 38,735 | 90.9% |
| General practice doctor | Comptroller | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Toxicologist | 42,624 | 38,735 | 90.9% |
| Education officer, community | Surveyor, land/geomatics | 42,624 | 38,735 | 90.9% |
| General practice doctor | Hospital doctor | 42,624 | 38,735 | 90.9% |
| Technical sales engineer | Accounting technician | 42,624 | 38,735 | 90.9% |
| General practice doctor | Equality and diversity officer | 42,624 | 38,735 | 90.9% |
| General practice doctor | Copywriter, advertising | 42,624 | 38,735 | 90.9% |
| Haematologist | Tax inspector | 42,624 | 38,735 | 90.9% |
| General practice doctor | Journalist, magazine | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Paediatric nurse | 42,624 | 38,735 | 90.9% |
| Interior and spatial designer | Psychotherapist, child | 42,624 | 38,735 | 90.9% |
| Engineer, civil (contracting) | Broadcast journalist | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Purchasing manager | 42,624 | 38,735 | 90.9% |
| Technical sales engineer | Advertising art director | 42,624 | 38,735 | 90.9% |
| General practice doctor | Chemist, analytical | 42,624 | 38,735 | 90.9% |
| Chief Financial Officer | IT technical support officer | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Editorial assistant | 42,624 | 38,735 | 90.9% |
| Technical sales engineer | Primary school teacher | 42,624 | 38,735 | 90.9% |
| Technical sales engineer | Contracting civil engineer | 42,624 | 38,735 | 90.9% |
| Town planner | Town planner | 42,624 | 38,735 | 90.9% |
| General practice doctor | Fast food restaurant manager | 42,624 | 38,735 | 90.9% |
| General practice doctor | Drilling engineer | 42,624 | 38,735 | 90.9% |
| General practice doctor | Commissioning editor | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | Land/geomatics surveyor | 42,624 | 38,735 | 90.9% |
| Chief Financial Officer | Therapist, horticultural | 42,624 | 38,735 | 90.9% |
| General practice doctor | Toxicologist | 42,624 | 38,735 | 90.9% |
| Financial risk analyst | Nurse, learning disability | 42,624 | 38,735 | 90.9% |
| General practice doctor | Scientist, research (maths) | 42,624 | 38,735 | 90.9% |
| General practice doctor | Magazine journalist | 42,624 | 38,735 | 90.9% |
| Chartered certified accountant | Nurse, learning disability | 42,624 | 38,735 | 90.9% |
| Chartered certified accountant | Interior and spatial designer | 42,624 | 38,735 | 90.9% |
| Trade union research officer | 42,624 | 38,735 | 90.9% | |
| Education officer, community | Educational psychologist | 42,624 | 38,735 | 90.9% |
| General practice doctor | Corporate treasurer | 42,624 | 38,735 | 90.9% |
| General practice doctor | Chartered accountant | 42,624 | 38,735 | 90.9% |
| Therapist, speech and language | 42,624 | 38,735 | 90.9% |
How recurring tickets distribute across priority levels. High-priority recurring tickets are the most expensive: they consume senior engineer time and often come with SLA pressure.
| Priority | Recurring Tickets | Share |
|---|---|---|
| P4 - Laag | 38,735 | 98.1% |
| Service/Change req. | 38,735 | 98.1% |
| P3 - Medium | 38,735 | 98.1% |
| P2 - Hoog | 38,735 | 98.1% |
| P1 - Kritisch | 38,735 | 98.1% |
Out of 42,624 tickets in the last 12 months, 92.6% are recurring issues. That means roughly 39,476 tickets could have been prevented if the underlying problem had been resolved the first time.
The cost of recurring tickets goes beyond the hours logged. Each repeat ticket erodes client trust, increases dispatch overhead, and takes time away from proactive work. When the same issue type keeps appearing at the same company, it signals one of three things: the fix was incomplete, the root cause was never identified, or the knowledge from the first resolution was never documented for the next engineer.
The monthly trend data shows whether the ratio is improving. If it stays flat or climbs, your team may need dedicated time for root-cause reviews after closing tickets in high-recurrence categories.
Practical steps to reduce your recurring ticket ratio based on the data above.
Pull the top five sub-issue types from Section 5.0 and assign a senior engineer to investigate why they keep coming back. Document findings and create standard operating procedures.
Clients with a recurring ratio above 40% need attention. Use the per-client data from Section 2.0 to prepare talking points for your next quarterly business review.
If your PSA does not have a mandatory root-cause field, add one. This gives you structured data to track whether engineers are actually diagnosing problems or just applying quick fixes.
A healthy MSP typically sees 20 to 25% recurring tickets. Set a target, add it to your monthly reporting, and review progress in team standups.
A ticket is recurring if the same company has logged at least one prior ticket with the same issue type and sub-issue type. The comparison uses the create_date field, so the first occurrence is always counted as "new."
Most well-run MSPs see between 20% and 25% recurring tickets. Below 20% is excellent. Above 35% suggests systemic issues that need root-cause analysis.
Yes. The DAX queries use date filters that you can adjust. Change the DATE() parameters to narrow or widen the window. All queries are included in the collapsible toggles.
This is a demo report using synthetic data. When you run it against your own Proxuma Power BI instance, real client names will appear.
Start with the top recurring sub-issue types. For each one, review the last five tickets, identify the root cause, and create a standard operating procedure. Then train your team on it. Track the ratio monthly to measure progress.
Connect Proxuma Power BI to your PSA, RMM, and M365 environment, use an MCP-compatible AI to ask questions, and generate custom reports - in minutes, not days.
See more reports Get started