# Data Table Visualization :: Autosort and Display only Top N? **URL:** \ **Category:** Kibana\ **Created:** [November 6, 2019, 10:10pm UTC](https://discuss.elastic.co/t/data-table-visualization-autosort-and-display-only-top-n/206867 "2019-11-06T22:10:42Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![redapplesonly](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/redapplesonly/32/57700_2.png) [@redapplesonly](https://discuss.elastic.co/u/redapplesonly)\ **Post date:** [November 6, 2019, 10:10pm UTC](https://discuss.elastic.co/t/data-table-visualization-autosort-and-display-only-top-n/206867/1 "2019-11-06T22:10:42Z")
Hi Kibana Gurus, I have a Data Table Visualization that works great. The full table contains hundreds of rows of data. When I look at the table, I can sort the table by a specific data field and limit the number of rows with the options or filters, etc. So far, so good. But I’m about to turn my Kibana dashboard over to our Operations group. The operators will not have any Kibana training, and they won’t want to fiddle with the options. The group’s manager likes my Data Table, but has two requests: - He wants the table to automatically sort on one specific column – it will always be the same column. - Once sorted, he only wants to see the top 10 rows. This seems simple enough. I’ve been researching the Kibana documentation, and I’m afraid I just can’t figure out how to approach this. Can anyone offer any suggestions? Thanks! ---
**Author:** ![AClerk](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aclerk/32/55297_2.png) [@AClerk](https://discuss.elastic.co/u/AClerk)\ **Post date:** [November 7, 2019, 4:45am UTC](https://discuss.elastic.co/t/data-table-visualization-autosort-and-display-only-top-n/206867/2 "2019-11-07T04:45:19Z")
I have a similar issue. > [@How to aggregate by value and get latest results](https://discuss.elastic.co/t/how-to-aggregate-by-value-and-get-latest-results/206514): > > Hi, I am trying to build a table visualisation to show all clusters in storage. In my specific example, I am expecting to have only 2 clusters, as there are only 2 unique cluster IDs. I am not able to aggregate and get the latest results only. How should that be done? I tried by Metric Aggregation: Top Hit Field: Cluster\_id Aggregate with: concatenate Size: 1 Sort on: @timestamp Order: Descending Also tried to get MAX timestamp, and all kind of try and error, with no luck. Current… Let's hope for an answer... Cheers! ---
**Author:** ![redapplesonly](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/redapplesonly/32/57700_2.png) [@redapplesonly](https://discuss.elastic.co/u/redapplesonly)\ **Post date:** [November 7, 2019, 2:46pm UTC](https://discuss.elastic.co/t/data-table-visualization-autosort-and-display-only-top-n/206867/3 "2019-11-07T14:46:16Z")
Indeed! I will watch your post and you watch mine and hopefully we can get the answers we need collectively. 🙂 thanks ---
**Author:** ![redapplesonly](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/redapplesonly/32/57700_2.png) [@redapplesonly](https://discuss.elastic.co/u/redapplesonly)\ **Post date:** [November 12, 2019, 11:49am UTC](https://discuss.elastic.co/t/data-table-visualization-autosort-and-display-only-top-n/206867/4 "2019-11-12T11:49:29Z")
Hi Kibana Gurus, Sorry to prod... any thoughts on this? Any help - pointing to a relevant tutorial, another post, even giving me some keywords to focus my Google searches - will be appreciated. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [December 10, 2019, 11:49am UTC](https://discuss.elastic.co/t/data-table-visualization-autosort-and-display-only-top-n/206867/5 "2019-12-10T11:49:31Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.