Unable to sort on @timestamp

[AaronKalair]

Hello,

I'm using Kibana v5.2.2 and Elasticsearch v5.2.2

I have Kibana setup to view my logs and I want to sort them by the @timestamp field but the little triangle that appears next to _score to let you sort by score doesn't appear next to @timestamp and I can't workout why?

[Stacey_Gammon]

Hmm, that should work in 5.2.2. It doesn't show up when you hover over timestamp?

What does the field look like under management? This is how mine looks and I was able to sort on it:

[AaronKalair]

Hey,

It doesn't appear if I hover over timestamp either, I just get an "X" symbol.

The field appears to be the same as yours under management

[Stacey_Gammon]

cc @lukas or @Bargs - you ever see anything like this?

[lukas (Lukas Olson)]

I haven't. Can you provide your mapping for this field? Are you able to sort by the "Time" column?

[AaronKalair]

Hey,

I can't sort on the Time column or well any column apart from _score actually.

My mapping for this field is ...

"@timestamp": {
    "type": "date"
}

[lukas (Lukas Olson)]

That's bizarre. I've tried in 5.2.2 and can't reproduce it. Maybe removing the index pattern and re-creating it would help?

[AaronKalair]

Hey,

I might be able to give that a go, I'll let you know if it helps.

I'm not hopeful though we've built 4 of these Elasticsearch / Kibana clusters with config management and they all have this issue, so I suspect we've done something wrong but I can't workout what it is

Thanks

[Bargs (Matt Bargar)]

I just took a look at the code and I also can't see how this could happen if your @timestamp field is a date and aggregatable, which it clearly is in the screenshot you posted.

Do you think you could create a minimal data set that reproduces this issue on a fresh kibana and ES install? If we could reproduce the issue we could debug it further, but at the moment I'm at a loss for what other questions to even ask.