Latest incident metric from list

naddiel
Kilo Contributor

‎01-24-2025 03:07 AM

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

 

0 Helpfuls
  • 208 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

‎01-24-2025 05:14 AM

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]

****************************************************************************************************************
0 Helpfuls