# Unable to sort on @timestamp

**URL:** <https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111>\
**Category:** Kibana\
**Created:** [April 23, 2018, 1:08pm UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111 "2018-04-23T13:08:19Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![AaronKalair](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaronkalair/32/30331_2.png) [@AaronKalair](https://discuss.elastic.co/u/AaronKalair)\
**Post date:** [April 23, 2018, 1:08pm UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111/1 "2018-04-23T13:08:20Z")

</div>

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?

 ![59](https://us1.discourse-cdn.com/elastic/original/3X/9/f/9f5bee7b25334c40ead4a85aed415c9e8996b1f0.png)

---

<div class="post-metadata">

**Author:** ![Stacey\_Gammon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stacey_gammon/32/14025_2.png) [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)\
**Post date:** [April 23, 2018, 3:36pm UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111/2 "2018-04-23T15:36:12Z")

</div>

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

 ![28%20AM](https://us1.discourse-cdn.com/elastic/original/3X/e/2/e2fef9e631fed394ddb9f3b25f373a74ed2ddc49.png)

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

 ![57%20AM](https://us1.discourse-cdn.com/elastic/original/3X/c/e/cecee321c0f0718251a7249fc75fdc436a9ef279.png)

---

<div class="post-metadata">

**Author:** ![AaronKalair](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaronkalair/32/30331_2.png) [@AaronKalair](https://discuss.elastic.co/u/AaronKalair)\
**Post date:** [April 23, 2018, 4:05pm UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111/3 "2018-04-23T16:05:07Z")

</div>

Hey,

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

![11](https://us1.discourse-cdn.com/elastic/original/3X/d/f/dfec5e00ff49ad9f4e6b448c2a119898d01f3c7b.png)

The field appears to be the same as yours under management

 ![17](https://us1.discourse-cdn.com/elastic/original/3X/f/c/fc2c3ade6844894f1cd9461f0fc6f81e593d00f9.png)

---

<div class="post-metadata">

**Author:** ![Stacey\_Gammon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stacey_gammon/32/14025_2.png) [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)\
**Post date:** [April 23, 2018, 4:40pm UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111/4 "2018-04-23T16:40:42Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [April 23, 2018, 8:25pm UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111/5 "2018-04-23T20:25:55Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![AaronKalair](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaronkalair/32/30331_2.png) [@AaronKalair](https://discuss.elastic.co/u/AaronKalair)\
**Post date:** [April 24, 2018, 7:49am UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111/6 "2018-04-24T07:49:51Z")

</div>

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"
}
```

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [April 24, 2018, 7:26pm UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111/7 "2018-04-24T19:26:50Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![AaronKalair](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaronkalair/32/30331_2.png) [@AaronKalair](https://discuss.elastic.co/u/AaronKalair)\
**Post date:** [April 24, 2018, 8:56pm UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111/8 "2018-04-24T20:56:26Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\
**Post date:** [April 26, 2018, 10:02pm UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111/9 "2018-04-26T22:02:25Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 24, 2018, 10:02pm UTC](https://discuss.elastic.co/t/unable-to-sort-on-timestamp/129111/10 "2018-05-24T22:02:30Z")

</div>

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