# Data table: How to create many columns from a field **URL:** \ **Category:** Kibana\ **Tags:** lens\ **Created:** [August 26, 2024, 7:26am UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534 "2024-08-26T07:26:13Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![JohanExpat](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@JohanExpat](https://discuss.elastic.co/u/JohanExpat)\ **Post date:** [August 26, 2024, 7:26am UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/1 "2024-08-26T07:26:14Z")
Hello, In index email\_stats i have a field called "event\_type" that can be equal to seven different values corresponding to the email status, i would like to create a column counting the occurence for each of them. I would also need with these result to create new column to display maths between them. Is there a way to do it ? (I'm using 6.8.17) Wanted result : ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/a/3a71d4f69564e7d49024297e2f08ef538a5cd676.png) My best try is using split table but it's kind of a mess: Thanks! ---
**Author:** ![JohanExpat](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@JohanExpat](https://discuss.elastic.co/u/JohanExpat)\ **Post date:** [August 26, 2024, 7:28am UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/3 "2024-08-26T07:28:37Z")
heres my best try: ![Untitled](https://us1.discourse-cdn.com/elastic/original/3X/f/f/ff300fdfe986e3f237f141bb816c189bab5338e2.png) ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [August 27, 2024, 9:00am UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/4 "2024-08-27T09:00:59Z")
Hi @JohanExpat what's your stack version? Also, can you post a couple of simple documents? That would help. ---
**Author:** ![JohanExpat](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@JohanExpat](https://discuss.elastic.co/u/JohanExpat)\ **Post date:** [August 27, 2024, 10:32am UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/5 "2024-08-27T10:32:48Z")
Thanks for your reply, Stack: 7.10.2 Documents: ```auto "hits" : [ { "_index" : "emailing_stats", "_type" : "_doc", "_id" : "1109743855", "_score" : 1.0, "_source" : { "event_id" : "1110256642", "user_id" : "267842", "user_status" : null, "segment" : "marketing", "email_type" : "Mailing tool", "event_type" : "Delivery", "date" : "2024-08-27 09:58:18", "language" : "en", "campaign" : null, "country" : null, "region" : "", "user_status_id" : "0", "email_type_id" : "12", "lang_id" : "0", "campaign_id" : "123456789", "country_id" : "0", "region_id" : "0", "emailing_id" : null } }, { "_index" : "emailing_stats", "_type" : "_doc", "_id" : "1109743856", "_score" : 1.0, "_source" : { "event_id" : "1110256643", "user_id" : "267842", "user_status" : null, "segment" : "marketing", "email_type" : "Mailing tool", "event_type" : "Injection", "date" : "2024-08-27 09:58:19", "language" : "en", "campaign" : null, "country" : null, "region" : "", "user_status_id" : "0", "email_type_id" : "12", "lang_id" : "0", "campaign_id" : "123456789", "country_id" : "0", "region_id" : "0", "emailing_id" : null } }, { "_index" : "emailing_stats", "_type" : "_doc", "_id" : "1109743893", "_score" : 1.0, "_source" : { "event_id" : "1110256680", "user_id" : "267842", "user_status" : null, "segment" : "marketing", "email_type" : "Mailing tool", "event_type" : "Open", "date" : "2024-08-27 09:58:46", "language" : "en", "campaign" : null, "country" : null, "region" : "", "user_status_id" : "0", "email_type_id" : "12", "lang_id" : "0", "campaign_id" : "123456789", "country_id" : "0", "region_id" : "0", "emailing_id" : null } } ] ``` As you can see the targeted field is "event\_type" Thanks ---
**Author:** ![JohanExpat](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@JohanExpat](https://discuss.elastic.co/u/JohanExpat)\ **Post date:** [September 3, 2024, 5:02am UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/6 "2024-09-03T05:02:17Z")
hey, any news ? ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [September 3, 2024, 8:14am UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/7 "2024-09-03T08:14:12Z")
Sorry, you mean something like this? ![Screenshot 2024-09-03 at 10.13.53](https://us1.discourse-cdn.com/elastic/original/3X/c/d/cd49c3d13a8d0216bfd6a13500bb04e0d0882b8d.png) ---
**Author:** ![JohanExpat](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@JohanExpat](https://discuss.elastic.co/u/JohanExpat)\ **Post date:** [September 3, 2024, 9:33am UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/8 "2024-09-03T09:33:51Z")
No, something like the wanted result exemple i posted first, with sent , open and click creating a column where the count is displayed in the row ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [September 3, 2024, 10:32am UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/9 "2024-09-03T10:32:43Z")
So something like that: ![Screenshot 2024-09-03 at 12.32.26](https://us1.discourse-cdn.com/elastic/original/3X/0/c/0ca4a45096c485619503c9068943c622ccd196d9.png) ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [September 3, 2024, 10:33am UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/10 "2024-09-03T10:33:06Z")
Added #lens ---
**Author:** ![JohanExpat](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@JohanExpat](https://discuss.elastic.co/u/JohanExpat)\ **Post date:** [September 3, 2024, 11:04am UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/11 "2024-09-03T11:04:44Z")
yes but i belive it's not available in my version, any alternative maybe ? ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [September 3, 2024, 12:25pm UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/12 "2024-09-03T12:25:13Z")
Unfortunately that stack version is very old. ---
**Author:** ![JohanExpat](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@JohanExpat](https://discuss.elastic.co/u/JohanExpat)\ **Post date:** [September 3, 2024, 12:59pm UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/13 "2024-09-03T12:59:28Z")
should i update the whole stack or just kibana to get the correct filters will be good enough ? ---
**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\ **Post date:** [September 3, 2024, 1:00pm UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/14 "2024-09-03T13:00:21Z")
Upgrade the entire stack is required in this case. ---
**Author:** ![JohanExpat](https://avatars.discourse-cdn.com/v4/letter/j/eada6e/32.png) [@JohanExpat](https://discuss.elastic.co/u/JohanExpat)\ **Post date:** [September 3, 2024, 1:00pm UTC](https://discuss.elastic.co/t/data-table-how-to-create-many-columns-from-a-field/365534/15 "2024-09-03T13:00:43Z")
thanks !