# How to split value in different coloum in data table **URL:** \ **Category:** Kibana\ **Created:** [January 20, 2021, 9:24am UTC](https://discuss.elastic.co/t/how-to-split-value-in-different-coloum-in-data-table/261624 "2021-01-20T09:24:45Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![tahseen\_fatima](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tahseen_fatima/32/67789_2.png) [@tahseen\_fatima](https://discuss.elastic.co/u/tahseen_fatima)\ **Post date:** [January 20, 2021, 9:24am UTC](https://discuss.elastic.co/t/how-to-split-value-in-different-coloum-in-data-table/261624/1 "2021-01-20T09:24:46Z")
Hi, I am using ELK 7.10v. I have a use case where I want to show _" Total brokerage amout of clients monthly wise."_ I have 3 fields :- client\_id, time and brokerage . I want my data table to look like this: ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/6/e66ddd8211f35f980167e4d822a4c079444a94b9.png) ``` Client_id 01-09-2020 01-10-2020 01-11-2020 ----- 12hdhs 18m 20m 44m ------- df2121 0 20k 10b ----------- csaf12 2.1b 55m 1.2b ------------ ``` kindly help. Regards, Tahseen ---
**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\ **Post date:** [January 20, 2021, 6:28pm UTC](https://discuss.elastic.co/t/how-to-split-value-in-different-coloum-in-data-table/261624/2 "2021-01-20T18:28:23Z")
How strictly do you need this format? This would normally be considered a pivot table and we don't generally support those in Kibana, but there are two main options: 1. Line charts can easily do this, for example if you use Lens to construct a line chart you will get the behavior you want. 2. If you really need this to be a table, you can use the Data Table visualization (not in Lens) and set your Split Chart to be based on a date histogram. This won't be condensed as easily as what you want, but it's close. Finally, you could use a standard table where each date is a separate row. This gives you the information but is more repetitive. ---
**Author:** ![tahseen\_fatima](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tahseen_fatima/32/67789_2.png) [@tahseen\_fatima](https://discuss.elastic.co/u/tahseen_fatima)\ **Post date:** [January 21, 2021, 3:51am UTC](https://discuss.elastic.co/t/how-to-split-value-in-different-coloum-in-data-table/261624/3 "2021-01-21T03:51:23Z")
HI @wylie 1. My client requirement is in data table. 2. I have already tried in (Data Table Visualization) by splitting the charts in columns, but it was not giving the exact picture what I want. Is there any other way to excute this use case in data table? Regards, Tahseen ---
**Author:** ![tahseen\_fatima](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tahseen_fatima/32/67789_2.png) [@tahseen\_fatima](https://discuss.elastic.co/u/tahseen_fatima)\ **Post date:** [January 22, 2021, 9:48am UTC](https://discuss.elastic.co/t/how-to-split-value-in-different-coloum-in-data-table/261624/4 "2021-01-22T09:48:58Z")
Hi @wylie I got a plugin from github _Kibana Enhanced Table Plugin._ [Enhanced Table Plugin](https://github.com/fbaligand/kibana-enhanced-table) By using this plugin I can full fill my requirements. Also I have a question can I use this plugin in a production environment? Regards, Tahseen ---
**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\ **Post date:** [January 22, 2021, 3:44pm UTC](https://discuss.elastic.co/t/how-to-split-value-in-different-coloum-in-data-table/261624/5 "2021-01-22T15:44:17Z")
That plugin is a popular choice among our users, but we don't officially have any recommendations on it. ---
**Author:** ![tahseen\_fatima](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tahseen_fatima/32/67789_2.png) [@tahseen\_fatima](https://discuss.elastic.co/u/tahseen_fatima)\ **Post date:** [January 22, 2021, 3:49pm UTC](https://discuss.elastic.co/t/how-to-split-value-in-different-coloum-in-data-table/261624/6 "2021-01-22T15:49:13Z")
Hi @wylie Thank you for the response, will not use this plugin in production environment. Hope to see this pivot feature in new version of kibana. Regards, Tahseen ---
**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\ **Post date:** [January 22, 2021, 6:32pm UTC](https://discuss.elastic.co/t/how-to-split-value-in-different-coloum-in-data-table/261624/7 "2021-01-22T18:32:00Z")
You can track our progress on adding it to Lens here: [https://github.com/elastic/kibana/issues/69450](https://github.com/elastic/kibana/issues/69450) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 19, 2021, 6:32pm UTC](https://discuss.elastic.co/t/how-to-split-value-in-different-coloum-in-data-table/261624/8 "2021-02-19T18:32:05Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.