Hey folks, I have data formatted as follows
time fielda fieldb
I want to find the top 3 values of fielda for each of fieldb, but for each result I need to know the time for which the top value occurred.
I found I can use top to get the top 3 fielda by fieldb, yet time is stripped from the table:
|top limit=3 fielda by fieldb
Is there a way to use top to maintain that data, or perhaps an alternative command or set of commands I can use to get what I'm looking for?
... View more