# Enhanced table **URL:** \ **Category:** Kibana\ **Created:** [April 9, 2022, 12:33am UTC](https://discuss.elastic.co/t/enhanced-table/302006 "2022-04-09T00:33:35Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Alejandra\_Mata1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alejandra_mata1/32/103936_2.png) [@Alejandra\_Mata1](https://discuss.elastic.co/u/Alejandra_Mata1)\ **Post date:** [April 9, 2022, 12:33am UTC](https://discuss.elastic.co/t/enhanced-table/302006/1 "2022-04-09T00:33:35Z")
Hi @fbaligand i would like to use enhanced table in 8.1 version .... will you able help me? ---
**Author:** ![fbaligand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fbaligand/32/5657_2.png) [@fbaligand](https://discuss.elastic.co/u/fbaligand)\ **Post date:** [April 9, 2022, 6:00am UTC](https://discuss.elastic.co/t/enhanced-table/302006/2 "2022-04-09T06:00:07Z")
Hi Well today, enhanced table is not compatible with kibana 8.1, nor 8.0. ---
**Author:** ![Alejandra\_Mata1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alejandra_mata1/32/103936_2.png) [@Alejandra\_Mata1](https://discuss.elastic.co/u/Alejandra_Mata1)\ **Post date:** [April 10, 2022, 7:06pm UTC](https://discuss.elastic.co/t/enhanced-table/302006/3 "2022-04-10T19:06:11Z")
Excuse me @fbaligand, and with enhanced table can I make a pivot table? I need to create the following table, and the variables are arrays. ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/4/b497c8b67448cf701293e16e983aeb0610c37e9a.png) I want to transpose these variables horizontally, but each one of them has the time below it like this: EL RECREO | CHIMBACALLE 06:05:01 | 06:10:02 ---
**Author:** ![fbaligand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fbaligand/32/5657_2.png) [@fbaligand](https://discuss.elastic.co/u/fbaligand)\ **Post date:** [April 10, 2022, 9:38pm UTC](https://discuss.elastic.co/t/enhanced-table/302006/4 "2022-04-10T21:38:46Z")
Well, yes, you can do a pivot table. On "Data" tab, in "Buckets" sections, add a "Split Cols" bucket. If you want to have the different values of "paradas" as columns, choose "Terms" aggregation with "paradas" field. Finally, if you want to be sure that columns are sorted by name, check "Order split cols" option in "Options" tab. ---
**Author:** ![Alejandra\_Mata1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alejandra_mata1/32/103936_2.png) [@Alejandra\_Mata1](https://discuss.elastic.co/u/Alejandra_Mata1)\ **Post date:** [April 10, 2022, 10:36pm UTC](https://discuss.elastic.co/t/enhanced-table/302006/5 "2022-04-10T22:36:33Z")
Thanks, I got here, but I want the time to be under each "parada", which I have in an array, each time is different for each "parada" ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/e/7e3952d237dc30a26988477c45f400dd28e6218f.png) instead of displaying the count , output the time ---
**Author:** ![fbaligand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fbaligand/32/5657_2.png) [@fbaligand](https://discuss.elastic.co/u/fbaligand)\ **Post date:** [April 11, 2022, 4:03am UTC](https://discuss.elastic.co/t/enhanced-table/302006/6 "2022-04-11T04:03:34Z")
Well, in the « Metrics » section, replace « Count » aggregation by « Top Hits » aggregation and choose « time » field. ---
**Author:** ![Alejandra\_Mata1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alejandra_mata1/32/103936_2.png) [@Alejandra\_Mata1](https://discuss.elastic.co/u/Alejandra_Mata1)\ **Post date:** [April 11, 2022, 4:34am UTC](https://discuss.elastic.co/t/enhanced-table/302006/7 "2022-04-11T04:34:42Z")
the entire array is assigned at each "parada", but I want each date to be assigned to a "parada" ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/9/49d910e5c9458aecfc423df13c5d149dabf23205.png) ---
**Author:** ![fbaligand](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/fbaligand/32/5657_2.png) [@fbaligand](https://discuss.elastic.co/u/fbaligand)\ **Post date:** [April 11, 2022, 9:11am UTC](https://discuss.elastic.co/t/enhanced-table/302006/8 "2022-04-11T09:11:20Z")
Well, it surprising… Are all paradas and times are on the same document? With an array of paradas and an array of times? If it is the case, it’s normal to see that. To make it work, you need a document for each parades - time pair. ---
**Author:** ![Alejandra\_Mata1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alejandra_mata1/32/103936_2.png) [@Alejandra\_Mata1](https://discuss.elastic.co/u/Alejandra_Mata1)\ **Post date:** [April 11, 2022, 5:00pm UTC](https://discuss.elastic.co/t/enhanced-table/302006/9 "2022-04-11T17:00:11Z")
Yes, the paradas and time are in the same document in an array. as I am doing the visualization of a vehicle trip, then this vehicle is going to have different paradas and each parada its time, so I could not separate in another document ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [May 9, 2022, 5:00pm UTC](https://discuss.elastic.co/t/enhanced-table/302006/10 "2022-05-09T17:00:39Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.