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  

[Asha Pathak]

@Shivalika 

Removed if condition , 

[Shivalika]

Hello @Asha Pathak 

Let me rephrase my question - please share the breakdown mappings and breakdown relations only for "formula indicator" - only this is breaking right ? Rest it's working fine. 

So you share only for that. 

Regards, 

Shivalika 

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

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

[Asha Pathak]

I have added assignment group breakdown in formula indicator and same in contributor indicators

[Asha Pathak]

@Shivalika , Is it correct?
or Do I need to add another screen shot

[Asha Pathak]

@Shivalika ,

Please reply