Performance analytics dashboards and indicator configuration.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-20-2023 03:46 AM
I have a requirement to create reports on performance analytics for
1) percentage of incidents that meet response SLA and
2) percentage of incidents that don't meet response SLA.
I have created indicator source, automated indicator and formula indicator for both reports. when i run the data collector job , data that i am getting inaccurate, data.
Ex : if meet response SLA for this month is 35% then
don't meet response SLA for this month has to be around 65% Both should be equal to 100% but here i am only getting 50% for both. can anyone help me solve this issue.
#performance analytics
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-20-2023 04:16 AM
Hi @prash4 ,
Sounds like your filter or/and configuration on the indicator source or indicator is not narrow enough. You need to look into the filtering of the data, as the indicator formula is "just" as basic calculation of the captured data.
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-20-2023 05:25 AM - edited 04-21-2023 05:50 AM
solved
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-20-2023 05:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-20-2023 06:39 AM
Hi @prash4 ,
- First of all, then I would have utilized the incident_sla OOTB database view instead of the task_sla table.
- Secondly, I would not utilize the created filter, as you can't say for sure, that all SLA has completed. This refer to, that the created on this month, can give a false positive. Instead you could utilize resolved or similar on last month, and then run it on the first of a month.
- When you utilize the created on this month, it's actually stated that the task is created on this month and not the incident itself.
- What about the indicator "Total number of incidents created on this month". Are you utilizing same filter/table?
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/