Given a set of filters, I want to get the most recent single row, including the timestamp of the row
I have rows, from 1:00 to 4:00.
I ingested a row matching my filter above at 2:00 & 3:00.
I want to make a query that will give me the row at 3:00.
My initial thought was using the Select query.
This seemed like the most straightforward solution.
However, Select doesnt work in a reverse fashion.
So in this case I will be getting the first occurence instead of the last occurence.
Any ideas on how to accomplish the above?