Select just 1 record in each group

PJ363182
Tera Contributor

‎03-09-2025 05:00 PM - edited ‎03-10-2025 05:08 PM

How can I filter out to show just the latest created time for each of the servers?

There will be just 1 incident, based on the latest date, listed for each server.

(The picture is not mine, just found it but it serves my purpose)

Preview file
50 KB
0 Helpfuls
  • 381 Views
4 REPLIES 4

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-10-2025 06:16 AM

Hi @PJ363182 

 

Could you please provide more details, what exactly you are looking for,.

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

PJ363182
Tera Contributor
In response to Dr Atul G- LNG

‎03-10-2025 03:48 PM

From the screenshot, there are 3 incidents listed for Server:I29TOK1. I would like just a single latest incident, INC0011715 in this case, listed for each of the servers.

0 Helpfuls

PJ363182
Tera Contributor
In response to Dr Atul G- LNG

‎03-10-2025 04:54 PM

As i have mentioned, I would like to a filter where there should be 1 record, which has the latest date, to appear under each server.

0 Helpfuls

PJ363182
Tera Contributor

‎03-12-2025 08:32 PM

the issue has been resolved.

0 Helpfuls