# Vertical Bar Chart Order by Percentage

**URL:** <https://discuss.elastic.co/t/vertical-bar-chart-order-by-percentage/32585>\
**Category:** Kibana\
**Created:** [October 20, 2015, 3:25pm UTC](https://discuss.elastic.co/t/vertical-bar-chart-order-by-percentage/32585 "2015-10-20T15:25:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mhuguenin](https://avatars.discourse-cdn.com/v4/letter/m/db5fbb/32.png) [@mhuguenin](https://discuss.elastic.co/u/mhuguenin)\
**Post date:** [October 20, 2015, 3:25pm UTC](https://discuss.elastic.co/t/vertical-bar-chart-order-by-percentage/32585/1 "2015-10-20T15:25:45Z")

</div>

I've created a vertical bar chart with Bar Mode=Percentage that aggregates 2 metrics and displays the results as a percentage.

For my buckets I'm using Terms Aggregation. And I want to get the top 10 terms ordered by Percentage.

Is there any way to do this in Kibana 4.1?

---

<div class="post-metadata">

**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\
**Post date:** [October 21, 2015, 4:58am UTC](https://discuss.elastic.co/t/vertical-bar-chart-order-by-percentage/32585/2 "2015-10-21T04:58:32Z")

</div>

Could you include a screenshot of your visualization with all options in the vis builder expanded, so we could see your config?

---

<div class="post-metadata">

**Author:** ![mhuguenin](https://avatars.discourse-cdn.com/v4/letter/m/db5fbb/32.png) [@mhuguenin](https://discuss.elastic.co/u/mhuguenin)\
**Post date:** [October 22, 2015, 12:18pm UTC](https://discuss.elastic.co/t/vertical-bar-chart-order-by-percentage/32585/3 "2015-10-22T12:18:54Z")

</div>

![](https://us1.discourse-cdn.com/elastic/original/2X/3/355a0575df81d26e81bb7ab48b27af9d217cb7e1.png)

Ok, here's a screenshot. First time I'm posting an image so hopefully the size and resolution are ok.

But it's easy to reproduce. Create a Vertical Bar Chart with Bar Type Percentage. Add any two metrics to the Y Axis. For the X Axis Add a Terms Metrics, Say for Top 5. The Order By Chooser offers any of the Y Axis Metrics or a single field custom metrics.

I would like to Order by Percentage ie I want the Top 5 Terms based on Percent.

---

<div class="post-metadata">

**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\
**Post date:** [October 23, 2015, 5:41am UTC](https://discuss.elastic.co/t/vertical-bar-chart-order-by-percentage/32585/4 "2015-10-23T05:41:26Z")

</div>

So, in 4.2 there is an explicit "order by" option, but it doesn't seem to work as I expect. I filed an issue:

> <https://github.com/elastic/kibana/issues/5179>

---

<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 6, 2017, 2:10pm UTC](https://discuss.elastic.co/t/vertical-bar-chart-order-by-percentage/32585/5 "2017-07-06T14:10:48Z")

</div>


