Query for formula indicator in Performance anylytics

Asha Pathak
Tera Contributor

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  

12 REPLIES 12

Shivalika
Mega Sage

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
Mega Sage

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

@Shivalika 

 

AshaPathak_0-1741610341862.png

 

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