# Get top results when ordering (asc) by term

**URL:** <https://discuss.elastic.co/t/get-top-results-when-ordering-asc-by-term/148809>\
**Category:** Kibana\
**Created:** [September 17, 2018, 10:32am UTC](https://discuss.elastic.co/t/get-top-results-when-ordering-asc-by-term/148809 "2018-09-17T10:32:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![yahuu](https://avatars.discourse-cdn.com/v4/letter/y/90db22/32.png) [@yahuu](https://discuss.elastic.co/u/yahuu)\
**Post date:** [September 17, 2018, 10:32am UTC](https://discuss.elastic.co/t/get-top-results-when-ordering-asc-by-term/148809/1 "2018-09-17T10:32:00Z")

</div>

In a kibana visualization i use a bucket aggregation where i order by term in an ascending order.

In my barchart 50 results are shown (size set to 50). These are the first 50 results of the ascending ordered results.  
However, i want the last 50 results in my barchart.

Here an example; the field i am aggregating is a version number:

Ordered results (ascending):  
1.1.0, 1.2.0, 2.0.0, 2.1.0

With size=2 i get 1.1.0 and 1.2.0.

How can i get 2.0.0 and 2.1.0 in my chart?  
Of course i could change the ordering to descending but then the ordering is wrong in the chart.

I hope my explanation is sufficient.  
Any help is much appreciated.

---

<div class="post-metadata">

**Author:** ![azasypkin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/azasypkin/32/42216_2.png) [@azasypkin](https://discuss.elastic.co/u/azasypkin)\
**Post date:** [September 17, 2018, 1:31pm UTC](https://discuss.elastic.co/t/get-top-results-when-ordering-asc-by-term/148809/2 "2018-09-17T13:31:26Z")

</div>

Hi @yahuu,

I'm afraid it's not currently possible, but let's wait, maybe someone else will come up with some smart idea.

Best,  
Oleg

---

<div class="post-metadata">

**Author:** ![yahuu](https://avatars.discourse-cdn.com/v4/letter/y/90db22/32.png) [@yahuu](https://discuss.elastic.co/u/yahuu)\
**Post date:** [September 17, 2018, 3:03pm UTC](https://discuss.elastic.co/t/get-top-results-when-ordering-asc-by-term/148809/3 "2018-09-17T15:03:31Z")

</div>

Unfortunate. Thanks for your reply anyways 🙂

---

<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:** [October 15, 2018, 3:03pm UTC](https://discuss.elastic.co/t/get-top-results-when-ordering-asc-by-term/148809/4 "2018-10-15T15:03:33Z")

</div>

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