FIltering Report on Metric Instance

Nagashree5
Tera Contributor

‎03-26-2025 03:52 AM

Hi All,

 

I've created a metric definition to track sprint changes and built a report on it. Now, I need to filter the report to show only stories that belong to a specific assignment group.

 

The issue is that I'm unable to dot walk to the ID field of te Metric Instance field as it is not a reference field. 

 

Has anyone faced this issue before? Any suggestions on how to achieve this filtering?

 

TIA.

0 Helpfuls
  • 1,218 Views
2 REPLIES 2

Dr Atul G- LNG
Tera Patron

‎03-26-2025 03:53 AM

Hi @Nagashree5 

 

For this, create a DB view of metric table and story table and then use that DB view for reports.

****************************************************************************************


Regards


Dr. Atul G. - Learn N Grow Together ServiceNow Techno - Functional Trainer


LinkedIn: https://www.linkedin.com/in/dratulgrover


YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG


****************************************************************************************************************
Known Issue in the ServiceNow Community


Currently, there is a limitation when embedding screenshots directly into a Community post or question. Members may not be able to download the image or zoom in sufficiently to view the details.


For better visibility and quicker resolution, you can either:


Attach the image as a file so members can download and view it at full resolution, or
Embed the image using a larger image size. This needs to be done manually when creating the post.


This is a known Community limitation and is worth keeping in mind when sharing screenshots that contain detailed information.

0 Helpfuls

Shivalika
Mega Sage

‎03-26-2025 04:03 AM

Hello @Nagashree5  

 

You need to pass sys_id in the ID field for it work. You need not dot walk. 

 

Refer below screenshot :- 

 

Shivalika_0-1742987005286.png

I have done the same for incidents. 

 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

 

Regards,

 

Shivalika 

 

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

 

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

0 Helpfuls