Need to return the most recent record by timestamp

Elastic Stack Elasticsearch
1

Hello everyone, I need to return the most recent record for every serial by timestamp
how can i query that ?
For e.g

Serial State . Time
AP01 . Up .
AP02 . Down
AP01 . Down
AP02 . UP

The output should be
AP01 . Up
AP02 . Down

Please suggest

Thanks in advance

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.