# Sorting of Terms aggregation buckets on Rollup indices

**URL:** <https://discuss.elastic.co/t/sorting-of-terms-aggregation-buckets-on-rollup-indices/158614>\
**Category:** Kibana\
**Created:** [November 28, 2018, 4:09pm UTC](https://discuss.elastic.co/t/sorting-of-terms-aggregation-buckets-on-rollup-indices/158614 "2018-11-28T16:09:09Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![programagor](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/programagor/32/40183_2.png) [@programagor](https://discuss.elastic.co/u/programagor)\
**Post date:** [November 28, 2018, 4:09pm UTC](https://discuss.elastic.co/t/sorting-of-terms-aggregation-buckets-on-rollup-indices/158614/1 "2018-11-28T16:09:09Z")

</div>

Greetings

I am trying to use the Terms aggregation on a rollup index, and I want the resulting buckets to be sorted, so that I can select the top 5 ones.  
Using raw data, everything looks as expected:

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

However, if I use a rollup index, the buckets are sorted by the key, not by the value:

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

Is there a way to adjust this behaviour?

---

<div class="post-metadata">

**Author:** ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)\
**Post date:** [November 28, 2018, 8:02pm UTC](https://discuss.elastic.co/t/sorting-of-terms-aggregation-buckets-on-rollup-indices/158614/2 "2018-11-28T20:02:56Z")

</div>

Thanks for reporting this! This is functionality we haven't implemented yet, so I've created an issue to track it: [https://github.com/elastic/kibana/issues/26372](https://github.com/elastic/kibana/issues/26372).

---

<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:** [December 26, 2018, 8:02pm UTC](https://discuss.elastic.co/t/sorting-of-terms-aggregation-buckets-on-rollup-indices/158614/3 "2018-12-26T20:02:57Z")

</div>

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