Query for formula indicator in Performance anylytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2025 05:29 AM
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.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2025 05:33 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2025 05:36 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2025 05:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-10-2025 05:41 AM
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