# Data Table Visualization :: Autosort and Display only Top N?

**URL:** <https://discuss.elastic.co/t/data-table-visualization-autosort-and-display-only-top-n/206867>\
**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:** 1\
**Showing post:** 2

<div class="post-metadata">

**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")

</div>

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!

---

_[View the full topic](https://discuss.elastic.co/t/data-table-visualization-autosort-and-display-only-top-n/206867)._