Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Latest incident metric from list

naddiel
Kilo Contributor

Hi,

 

I'm querying the incident metric table , to get the assignment groups (not part of an exception list) of an incident.

How can I get only the latest one (see yellow marked) for each incident from that list ? (a kind of max start date)

 

naddiel_0-1737716570834.png

 

1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @naddiel 

 

You need to create a report for this, where you can set conditions like "start date 2/4/5 hours ago," which is not possible directly on a related list.

*************************************************************************************************************
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]

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