# How to see the data in order of insertion in Data Table Visualization?
**URL:** https://discuss.elastic.co/t/how-to-see-the-data-in-order-of-insertion-in-data-table-visualization/112658
**Category:** Kibana
**Created:** [December 20, 2017, 2:58pm UTC](https://discuss.elastic.co/t/how-to-see-the-data-in-order-of-insertion-in-data-table-visualization/112658 "2017-12-20T14:58:23Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@mIsabelcc](https://discuss.elastic.co/u/mIsabelcc)
#### Post date: [December 20, 2017, 2:58pm UTC](https://discuss.elastic.co/t/how-to-see-the-data-in-order-of-insertion-in-data-table-visualization/112658/1 "2017-12-20T14:58:23Z")
I have an array that I need to see in order of insertion.
I charge with logstash:
....
aggregate {
task\_id =\> "%{taskid}"
code =\>"
map['fecha\_trx'] = event.get('@fecha\_trx')
map['numerohc'] = event.get('numerohc')
map['mensajes'] ||= [];
map['mensajes'] \<\< event.get('mensajes');
event.cancel()
"
}
....
---
### Author:  [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [December 20, 2017, 6:46pm UTC](https://discuss.elastic.co/t/how-to-see-the-data-in-order-of-insertion-in-data-table-visualization/112658/2 "2017-12-20T18:46:32Z")
Can you describe your use case a little more? I am not sure what you are asking
---
### Author:  [@mIsabelcc](https://discuss.elastic.co/u/mIsabelcc)
#### Post date: [December 26, 2017, 12:24pm UTC](https://discuss.elastic.co/t/how-to-see-the-data-in-order-of-insertion-in-data-table-visualization/112658/3 "2017-12-26T12:24:57Z")
when I use a Visualize Data Table to show data, I don't have the option to order this field to order that I insert, I only have this options: term, metric:... and custom metric
For example I insert data in this order:
Yelow
Blue
pink
But when I use a Visualize Data Table, Only can to show:
Blue
Pink
Yelow
or
Yelow
Pink
Blue
But I want to show:
Yelow
Blue
pink
---
### Author:  [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [January 2, 2018, 2:28pm UTC](https://discuss.elastic.co/t/how-to-see-the-data-in-order-of-insertion-in-data-table-visualization/112658/4 "2018-01-02T14:28:52Z")
The data table visualization shows elasticsearch aggregations results. It is not possible to order elasticsearch aggregation results by document insertion order
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 30, 2018, 2:35pm UTC](https://discuss.elastic.co/t/how-to-see-the-data-in-order-of-insertion-in-data-table-visualization/112658/5 "2018-01-30T14:35:20Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.