# DataTable visualization order by timestamp, desending

**URL:** https://discuss.elastic.co/t/datatable-visualization-order-by-timestamp-desending/245068
**Category:** Kibana
**Created:** [August 15, 2020, 2:27am UTC](https://discuss.elastic.co/t/datatable-visualization-order-by-timestamp-desending/245068 "2020-08-15T02:27:29Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![ElasticLiver](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elasticliver/32/64869_2.png) [@ElasticLiver](https://discuss.elastic.co/u/ElasticLiver)
#### Post date: [August 15, 2020, 2:27am UTC](https://discuss.elastic.co/t/datatable-visualization-order-by-timestamp-desending/245068/1 "2020-08-15T02:27:29Z")

</div>

Hi, Im trying to order a data table visualization by timestamp,but always one row is misplaced, ( i solve this clicking in the arrow of the header of the row) and often I get missing rows when I compare it with discover.  
this is what I do:

 ![Sin título](https://us1.discourse-cdn.com/elastic/original/3X/b/c/bca779d7a1d05228317634c38cf966d590b70cee.png)

I start with a top hit agregation in the @timestamp field, then for the others columns of the table I use terms agregation order by max @timestamp.

Does anyone know how is the best way to order rows by timestamp?

---

<div class="post-metadata">

### Author: ![flash1293](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/flash1293/32/41227_2.png) [@flash1293](https://discuss.elastic.co/u/flash1293)
#### Post date: [August 18, 2020, 8:18am UTC](https://discuss.elastic.co/t/datatable-visualization-order-by-timestamp-desending/245068/2 "2020-08-18T08:18:36Z")

</div>

Are you using multiple bucket aggregations in your data table?

---

<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: [September 15, 2020, 8:18am UTC](https://discuss.elastic.co/t/datatable-visualization-order-by-timestamp-desending/245068/3 "2020-09-15T08:18:40Z")

</div>

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