Incident SLA Reports

[Peter Williams]

I am looking for a way to generate an SLA report base on if the incident was taken care of at the 50% and at the Breach (100%) make

the report should show the number of incidents between 50%-99% and number of incidents that was breached or pass the 100% mark.

so far i am not able to find any fields or things that will do this in the report

[Dr Atul G- LNG]

Hi @Peter Williams 

It is not available OOTB, as this required calculation. PA is best approach for this.

There are OOTB Database view of Incident and Task SLA table, try to use that and get report.

[SLK Gupta]

Hi @Peter Williams ,

As per your requirement you need to create a SLA report based its time like 50%, 100% like that.
below steps can assist you in fulfilling your requirement @Peter Williams .

Navigate to task_sla.list table.

filter for incidents only:

Now look at the business elapsed percentage and select three dots on the coloumn context menu

select Bar chart on it @Peter Williams 

Once you selected it will navigate you to the report, name the report as per your requirement and select the Stack by SLA DEFINITION and For Aggregation select SUM and for percentage caliculation use RECORD NUMBER

Then Select RUN button (which is available on the top right corner)

The final report looks like this, these above steps will give youbsome insights on how to achieve your requirement @Peter Williams .

If my answer helps you in anyway please mark it as accepted solution or helpful @Peter Williams .

Thanks & Regards,

S. Lakshmikanth Gupta.

[Peter Williams]

is there a way to have a rang like

sum of all items between 0%-49% then sum of items 50%-99% and 100%>

[SLK Gupta]

I am looking into that specific detail @Peter Williams , 

Meanwhile you can have a workaround with this report as well. 

So you can get some solution meanwhile. 

Previously we don't have the report, now we have the report and we need to adjust the range only.

Please mark my answer as helpful or accepted solution if it assists you in anyway Peter. 

Thanks & Regards, 

S. Lakshmikanth Gupta