# Kibana Get Top 10 in Table Not Accurate

**URL:** <https://discuss.elastic.co/t/kibana-get-top-10-in-table-not-accurate/52294>\
**Category:** Kibana\
**Created:** [June 9, 2016, 7:28am UTC](https://discuss.elastic.co/t/kibana-get-top-10-in-table-not-accurate/52294 "2016-06-09T07:28:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ivanandrianto95](https://avatars.discourse-cdn.com/v4/letter/i/48db29/32.png) [@ivanandrianto95](https://discuss.elastic.co/u/ivanandrianto95)\
**Post date:** [June 9, 2016, 7:28am UTC](https://discuss.elastic.co/t/kibana-get-top-10-in-table-not-accurate/52294/1 "2016-06-09T07:28:56Z")

</div>

I need to display top 10 request in tablet using Kibana. If I choose Split Rows with Aggregation: terms, Field: request.raw, Order by: metric: Count, Order: descending, and size: 10, it will select only 10 rows (not the top 10) then sort those rows. How to make it sort all rows first and display the top 10 in desc order?

---

<div class="post-metadata">

**Author:** ![dkspace](https://avatars.discourse-cdn.com/v4/letter/d/bc79bd/32.png) [@dkspace](https://discuss.elastic.co/u/dkspace)\
**Post date:** [June 9, 2016, 3:11pm UTC](https://discuss.elastic.co/t/kibana-get-top-10-in-table-not-accurate/52294/2 "2016-06-09T15:11:25Z")

</div>

first you have to use in Y - count.  
next split chart columns (Terms) count 10 - it is top 10.

Please try .

---

<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, 1:50pm UTC](https://discuss.elastic.co/t/kibana-get-top-10-in-table-not-accurate/52294/3 "2017-07-06T13:50:59Z")

</div>