Calculation is not completing and duration is not calculating on metric instance

Bindhu1
Tera Contributor

Hi All,

I have a requirement, where I have to create metric definition when incident is assigned to some specific groups where parent is ABC, I am able to add the condition and metric instances are getting created but when the assignment group is assigned to some other group or if assignment group is emptied the calculation is not completing and duration is not calculated, can someone help me on this? kindly refer below screen shots

Bindhu1_0-1744175624347.png

 

Bindhu1_2-1744175798339.png

 

 

Thanks in advance.

 

7 REPLIES 7

Shivalika
Mega Sage

Hello @Bindhu1 

 

Why are you creating this custom ? It already exists in OOB and its already in perfect format - 

 

Shivalika_0-1744175998729.png

 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

 

Regards,

 

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

 

Hi Shivalika, 

Thanks for replying, I want to get the metric instances recorded for assignment groups where parent group is ABC, I am unable to dot walk and get this on report, so I have used condition in the script.

Hello @Bindhu1 

 

Create a Database view between metric instance and incident table. Altering the metric definition is not required. I will try this out and share screenshot shortly. 

 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

 

Regards,

 

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

Hello @Bindhu1 

 

Thanks for marking it as helpful. Please accept solution as this is working as I have shown in the screenshots. This will help me be recognized for the efforts I put into solving this immediately and also assist future readers with similar queries. 

 

 Regards,

 

Shivalika 

 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

 

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY