get the latest value in an array

[garumaru]

Hi Guys,

I am working on searching data from Servicenow ticket, and tickets normally have some status for example:

#Ticket     #Status   #Time

Ticket1       Open        Sep 01

Ticket1       Closed     Sep 02

Ticket2        Open        Sep 01

Ticket2        Pending   Sep 03

How can I get a table only list the latest status like below:

#Ticket     #Status   #Time

Ticket1       Closed     Sep 02

Ticket2        Pending   Sep 03

Thank you!

[garumaru]

Thanks @thambisetty , I was using table but didn't think using stats.

[thambisetty · Accepted solution]

| stats latest(Status) as Status latest(_time) as _time by Ticekt