Quick answer
Ticket Resolution Time is commonly calculated as:
Total Time to Resolve / Resolved TicketsExcel version:
=B2/C2Example table
| Metric | Example value |
|---|---|
| Numerator / current value | 120,000 |
| Denominator / base value | 400,000 |
| Ticket Resolution Time | 30% |
How to calculate it in Excel
- Create one column for each input in the KPI formula.
- Paste the Excel formula in the result column.
- Replace B2, C2, and D2 with the cells from your own sheet.
- Format ratio KPIs as Percentage and money KPIs as Currency.
- Compare the KPI over time, by team, or by channel instead of looking at one isolated number.
Power BI DAX version
For dashboards, create a measure and adapt the table and measure names to your model.
Ticket Resolution Time = DIVIDE([Numerator], [Denominator], 0)Tips
- Keep the numerator and denominator definitions consistent across reports.
- Document whether the KPI is monthly, quarterly, annual, trailing, or point-in-time.
- Use the same calculation logic in Excel and Power BI when comparing reports.