# Sorting on numeric columns in Discover 7.7.0 not working as expected

**URL:** <https://discuss.elastic.co/t/sorting-on-numeric-columns-in-discover-7-7-0-not-working-as-expected/234693>\
**Category:** Kibana\
**Created:** [May 28, 2020, 8:45am UTC](https://discuss.elastic.co/t/sorting-on-numeric-columns-in-discover-7-7-0-not-working-as-expected/234693 "2020-05-28T08:45:01Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![jsteenkamp](https://avatars.discourse-cdn.com/v4/letter/j/58956e/32.png) [@jsteenkamp](https://discuss.elastic.co/u/jsteenkamp)\
**Post date:** [May 28, 2020, 8:45am UTC](https://discuss.elastic.co/t/sorting-on-numeric-columns-in-discover-7-7-0-not-working-as-expected/234693/1 "2020-05-28T08:45:01Z")

</div>

- msg.time field has the default format in the Kibana index
- on MacOS 10.15.5 on latest version of Firefox, Brave and Safari browsers

unsorted

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/f/af99a7850c019759d51b2b0ef8b744423ac83879.png)

time ascending

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/3/b3ee2b48df6dc00acc667453f16af3ad6bbeeb42.png)

time descending

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/a/ca717645bdb43146440db3e75eecc5fb902a34cc.png)

---

<div class="post-metadata">

**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\
**Post date:** [May 29, 2020, 10:28pm UTC](https://discuss.elastic.co/t/sorting-on-numeric-columns-in-discover-7-7-0-not-working-as-expected/234693/2 "2020-05-29T22:28:46Z")

</div>

It kind of looks like those number are sorted alphabetically. Can you check the mapping in Elasticsearch for this field? It's unclear what `default format` actually is.

---

<div class="post-metadata">

**Author:** ![jsteenkamp](https://avatars.discourse-cdn.com/v4/letter/j/58956e/32.png) [@jsteenkamp](https://discuss.elastic.co/u/jsteenkamp)\
**Post date:** [May 30, 2020, 6:58am UTC](https://discuss.elastic.co/t/sorting-on-numeric-columns-in-discover-7-7-0-not-working-as-expected/234693/3 "2020-05-30T06:58:56Z")

</div>

Hi Tim,

Elasticsearch index mapping for this field:

```auto
"time": {
  "type": "long"
}

```

Kibana index pattern field settings:

- type: number
- format: Number

---

<div class="post-metadata">

**Author:** ![jsteenkamp](https://avatars.discourse-cdn.com/v4/letter/j/58956e/32.png) [@jsteenkamp](https://discuss.elastic.co/u/jsteenkamp)\
**Post date:** [June 9, 2020, 7:28am UTC](https://discuss.elastic.co/t/sorting-on-numeric-columns-in-discover-7-7-0-not-working-as-expected/234693/4 "2020-06-09T07:28:18Z")

</div>

This morning I have upgraded the Elastic stack to version 7.7.1. I can still reproduce this unexpected behaviour.

---

<div class="post-metadata">

**Author:** ![tsullivan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tsullivan/32/31077_2.png) [@tsullivan](https://discuss.elastic.co/u/tsullivan)\
**Post date:** [June 9, 2020, 5:27pm UTC](https://discuss.elastic.co/t/sorting-on-numeric-columns-in-discover-7-7-0-not-working-as-expected/234693/5 "2020-06-09T17:27:16Z")

</div>

Hi, this behavior sounds like a bug. Would you mind going to [https://github.com/elastic/kibana/issues](https://github.com/elastic/kibana/issues) and search to see if any known bugs match this issue? If not, please go ahead and file a new bug. Thanks,

-Tim

---

<div class="post-metadata">

**Author:** ![jsteenkamp](https://avatars.discourse-cdn.com/v4/letter/j/58956e/32.png) [@jsteenkamp](https://discuss.elastic.co/u/jsteenkamp)\
**Post date:** [June 13, 2020, 8:25am UTC](https://discuss.elastic.co/t/sorting-on-numeric-columns-in-discover-7-7-0-not-working-as-expected/234693/6 "2020-06-13T08:25:49Z")

</div>

> <https://github.com/elastic/kibana/issues/69109>
>
> Kibana version: 7.7.0 and 7.7.1
> Elasticsearch version: 7.7.0 and 7.7.1
> Server OS version: Debian 10.4
> Browser version:
> Firefox 77.0.1, Brave Version 1.9.80
> Chromium: 81.0.4044.138 (Official Build)...

---

<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:** [July 11, 2020, 8:25am UTC](https://discuss.elastic.co/t/sorting-on-numeric-columns-in-discover-7-7-0-not-working-as-expected/234693/7 "2020-07-11T08:25:52Z")

</div>

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