How to calculate total Elapsed time for INCIDENT SLA in Report

[Shree14]

Hi Folks,

We have a report built on SLA table(incident_sla), where we get elapsed time for task SLAs.

Now we have a requirement to get the toal elapsed time of all task sla. 

please respond if there is any approach to calculate total elapsed time for a INC.

Regards,

Shree

[AndersBGS]

Hi @Shree14 ,

Please share some more details about your requirement " get the total elapsed time of all task sla". Do you just want a sum of the actual elapsed time from the task_sla database view?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[Shree14]

I have the below details in Incident_sla table & yes want the sum of elapsed time in days and total %.

[AndersBGS]

Hi @Shree14 ,

Got it, I would recommend you to create a Performance Analytics report with one automated indicator that sums up the elapsed time, and one formula indicator which gives you the average percentage pr. day. Tis can be calculated by the formula [[sum of actual elapsed percentage completed today]] / [[count of actual elapsed percentage completed today]].

Both indicators can be showed in same widget where you can utilize left axis as sum of elapsed time and right axis as percentage actual elapsed time.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders 

[Dr Atul G- LNG]

Hi @Shree14 

Not sure, but do you need total of elapsed time. Try this:

Report on Task_SLA

and define function.