Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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

Rikke Pedersen
Kilo Explorer

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?

 find_real_file.png

 

 

 

3 REPLIES 3

sandeep24
Kilo Sage

Hi Rikke,

User metrics

find_real_file.png

 

find_real_file.png

Hi Rikke Pedersen,

 

Is the solution helped for you?

 

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.