FIltering Report on Metric Instance

Nagashree5
Tera Contributor

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.

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Nagashree5 

 

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

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

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
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

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

Shivalika
Mega Sage

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