How to calculate tickets age for (Incidents and Service Requests)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2019 02:09 AM
I need to be able to measure the percentages of tickets that are older than 30 days.
I have build an SLA that will count days open on an ticket named SLA 3-17 Ticket Ageing and it will breach when it is more than 30 days.
I am measuring the SLA as a monthly result i.e. at the end of April I am measuring the period like below:
Nominator: Total tickets opened in April
Denominator: Resolved tickets with age over 30 days + Open tickets with age over 30 days + Total tickets opened in April
The issue which I am facing is to get the correct number for the indicator Open tickets with age over 30 days my issue is that when I am using the source Incidents.SLA.Open it will give me what has breached on every day hence an incident can be breached on day one, and when running the job on day 2 it will be counted once more so I will have many entries for the same incident and the number from this indicator will be way to high.
I have setup the indicator which look like below – The incident will only be counted the day where the tickets will breach which gives me only one count per breached incident.
My issue/challenges is that I have tickets that are breached before we enter into the month which are still open. How do I count all the incidents that are Active and breached before the calculated Month in this example April?
- Labels:
-
Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2019 02:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2019 03:03 AM
Hi Rikke Pedersen,
Is the solution helped for you?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2019 06:09 AM
Hi Sandeep,
I am not sure this will help me. I already have the measurement it is more how I set this up in PA with an indicator.