Query for formula indicator in Performance anylytics

[Asha Pathak]

Hello Community!

I have added below query in formula indicator.
[[Sum of Business resolve duration of all incidents]] / [[Total number of incidents]]

It showing correct result.

https://www.servicenow.com/community/itsm-forum/dashboard-showing-mttr-month-over-month-for-12-month...

This is my article which shows in details of formula indicator

I have added one breakdown for the assignment group.

But when applying breakdown , formula not working
Please tell me the query for assignment group condition?

I have added assignment breakdown in MTTR formula indicator  

[Shivalika]

Hello @Asha Pathak 

Thanks for starting new thread, let me go through your query and get back to you. 

Regards, 

Shivalika 

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

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

ISQCY

[Shivalika]

Hello @Asha Pathak 

Please share screenshot of your breakdown as well. In the previous post only contributing indicators related list was visible. 

Regards, 

Shivalika 

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

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

[Asha Pathak]

@Shivalika 

[Shivalika]

Hello @Asha Pathak 

This is formula indicator screenshot - please share screenshot of "breakdowns" related list in this. 

Also why have you used if() ? I guess it's not needed. Please remove that. 

Regards, 

Shivalika 

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

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

ISQCY