# Data table with percentiles: Using multiple fields and having a row for each field **URL:** \ **Category:** Kibana\ **Created:** [June 16, 2016, 11:19am UTC](https://discuss.elastic.co/t/data-table-with-percentiles-using-multiple-fields-and-having-a-row-for-each-field/52981 "2016-06-16T11:19:47Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![PatriciaSauer](https://avatars.discourse-cdn.com/v4/letter/p/a3d4f5/32.png) [@PatriciaSauer](https://discuss.elastic.co/u/PatriciaSauer)\ **Post date:** [June 16, 2016, 11:19am UTC](https://discuss.elastic.co/t/data-table-with-percentiles-using-multiple-fields-and-having-a-row-for-each-field/52981/1 "2016-06-16T11:19:47Z")
Hello, is it possible to have a data table containing percentiles for multiple fields where each field gets its own row? Something like this: ``` | 5th percentile | 50th percentile | 95th percentile field 1 | data of field 1 | data of field 1 | data of field 1 field 2 | data of field 2 | data of field 2 | data of field 2 ``` Thanks. ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [June 17, 2016, 5:30pm UTC](https://discuss.elastic.co/t/data-table-with-percentiles-using-multiple-fields-and-having-a-row-for-each-field/52981/2 "2016-06-17T17:30:03Z")
Yes, this is possible. After you've created the data table, under the "metrics" heading, instead of choosing "Count", you can select "Percentiles" as the aggregation type. Hope this helps! ---
**Author:** ![PatriciaSauer](https://avatars.discourse-cdn.com/v4/letter/p/a3d4f5/32.png) [@PatriciaSauer](https://discuss.elastic.co/u/PatriciaSauer)\ **Post date:** [June 20, 2016, 6:35am UTC](https://discuss.elastic.co/t/data-table-with-percentiles-using-multiple-fields-and-having-a-row-for-each-field/52981/3 "2016-06-20T06:35:16Z")
Thanks for your reply. Unfortunately, this was not my question. I know that I can create tables which contain percentiles. But what if I wanted to have the percentiles for several fields within one table? If I create another metric and select percentiles, then the percentiles for the second field are listed next to each other, e.g.: `5th percentile -| 95th percentile | 5th percentile -| 95th percentile data of field 1 | data of field 1 | data of field 2 | data of field 2` But what I want is that they are listed below each other, e.g.: `--------| 5th percentile -| 50th percentile | 95th percentile field 1 | data of field 1 | data of field 1 | data of field 1 field 2 | data of field 2 | data of field 2 | data of field 2` Note: Hyphens are only inserted for formatting purposes. I hope this describes my intention. Do you have any idea? Thanks a lot ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [June 21, 2016, 4:22pm UTC](https://discuss.elastic.co/t/data-table-with-percentiles-using-multiple-fields-and-having-a-row-for-each-field/52981/4 "2016-06-21T16:22:30Z")
Oh, I understand. Unfortunately, it's not currently possible to do this. ---
**Author:** ![PatriciaSauer](https://avatars.discourse-cdn.com/v4/letter/p/a3d4f5/32.png) [@PatriciaSauer](https://discuss.elastic.co/u/PatriciaSauer)\ **Post date:** [June 22, 2016, 4:43am UTC](https://discuss.elastic.co/t/data-table-with-percentiles-using-multiple-fields-and-having-a-row-for-each-field/52981/5 "2016-06-22T04:43:00Z")
Ok. Thank you very much. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:49pm UTC](https://discuss.elastic.co/t/data-table-with-percentiles-using-multiple-fields-and-having-a-row-for-each-field/52981/6 "2017-07-06T13:49:37Z")
Closed on July 6, 2017, 1:49pm UTC