Percentage in formula indicator is showing beyond 100% in Performance Analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-22-2022 11:48 PM - edited ‎11-22-2022 11:51 PM
Hi,
I have created a performance analysis dashboard for getting the percentage of incident respond and resolved within breached time and added widget. The widget contains the formula indicator where i put my required formula as well as the breakdown as an "Assignment Group". But for some of the assignment group the percentage is exceeding 100% which is wrong. I have added the historic scheduled job which ran only once a day.
Can anyone please suggest on what can be done over here. It would be really helpful. I have attached the Analytic tab Screenshot.
Thanks,
Chake
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-23-2022 12:02 AM
Hi @Chake18 ,
Please refer below thread.
Performance Analytics Score in Formula indicators for percentage calculation(%)
Please Mark My Response as Correct/Helpful based on Impact
Regards,
Gunjan Kiratkar
2X ServiceNow MVP
Community Rising Star 2022
Youtube : ServiceNow Guy
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-23-2022 12:05 AM - edited ‎11-23-2022 12:05 AM
HI,
My formula is correct. and it is working fine and giving correct percentage except for some assignment group.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2023 02:29 AM
Check "Collect breakdown matrix " box for all the contributing indicators.
It will fix that issue.
Mark helpful if this worked.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-15-2023 02:31 AM
Check the "Collect breakdown matrix" box
it will fix the issue.
Mark Helpful if it is correct.
