Lens Table is always sorted on "oldest" / leftmost column - need to sort on "newest" / rightmost column

I have created a Table, where I would like for it to automatically sort records on the column having the newest date, but it defaults to sorting on the oldest date… we use this on a overhead screen showing general status for all to see, so it should ideally be hands-free.

I know I can manually click on the newest date to get the little sort arrow, but it resets every time we reload the dashboard.

Is this possible?

(i’m on Kibana 9.0.3, and couldn’t see any enhancements in more recent versions in this regard)

Here’s the table:

Regards,
Erik

Hello @Erik_Reuter

Welcome to the Community!!

you are right, i was unable to sort on the last column as the new week gets added to the table automatically so the table is dynamic when we have new records in the index. I believe we add Split by metrics as timestamp, correct ?

Just a thought can we reverse the table by which it will always sort on timestamp which will be our first column?

Thanks!!