The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Unable to group by ID field on Metric Instance table

bhupellygopi95
Tera Contributor

Hello all,

There is a requirement to create a report on number of Assignment groups an Incident has passed and also the time spent on each assignment group. I have created a report on Metric Instance table with definition as Assignment Group and grouped it by ID field.

bhupellygopi95_0-1723700055115.png

It is working as expected in my PDI. But when I am trying to execute the same in our customer instance, I am facing some issue. All the records are showing up in the report before I group it by ID, but after I group it by ID, only few records are showing in the report and recently created incident are not showing up here. Below is the screenshot of customer instance.

bhupellygopi95_1-1723700289763.png

Even if you see the number of results it is showing 1 of 1 instead of showing actual number 

Below is the screenshot of list view of Metric Instance table with same filter and grouping by ID

bhupellygopi95_2-1723700444557.png

Any answers are highly appreciated. Thankyou

1 REPLY 1

Najmuddin Mohd
Mega Sage

Hi @bhupellygopi95 ,
The similar requirement can be done by a plugin SLA Breakdowns. ID: com.snc.sla.breakdowns

It provides the ability to generate breakdown data for each Task SLA record, by Assignment group and Assigned to.

Check the below thread for it's advantage over metric table.
https://www.servicenow.com/community/itsm-forum/what-advantages-does-sla-breakdowns-have-compared-to...

If this information helps you, kindly mark this post as Helpful.

Regards,
Najmuddin.