# Possible to show multiple columns on a data table? **URL:** \ **Category:** Kibana\ **Created:** [July 23, 2019, 5:38pm UTC](https://discuss.elastic.co/t/possible-to-show-multiple-columns-on-a-data-table/191880 "2019-07-23T17:38:18Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![cgmelastic](https://avatars.discourse-cdn.com/v4/letter/c/b5ac83/32.png) [@cgmelastic](https://discuss.elastic.co/u/cgmelastic)\ **Post date:** [July 23, 2019, 5:38pm UTC](https://discuss.elastic.co/t/possible-to-show-multiple-columns-on-a-data-table/191880/1 "2019-07-23T17:38:18Z")
I'm fairly proficient with Data Table visualizations, but have mostly kept them to 2-3 columns. E.G. `|bucket|count|` or something like `|bucket|count|sibling aggregation|`. Now I'd like to do something a little more complicated. I'd like to bucket the data table as usual, but I'd like many columns. I don't mind if I have to define each one individually, but I want something like `|bucket|count where 'result' field NEGATIVE|count where 'result' field POSITIVE|count where 'accepted' field is ACCEPTED|count where 'accepted' field is REJECTED|`. However, the only way I know to get counts for various fields being a specific value is the query and filters at the top (which would eliminate other values of `result` and/or `accepted`). Also, the only way I know how to add more columns is to add more metrics. Is it possible to add a filter to a specific metric? That's the only way I have thought of that might make this work. Am I overlooking something? ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [July 24, 2019, 5:32pm UTC](https://discuss.elastic.co/t/possible-to-show-multiple-columns-on-a-data-table/191880/2 "2019-07-24T17:32:50Z")
Hey @cgmelastic this isn't possible currently using the Data Table visualization. If you could give [https://github.com/elastic/kibana/issues/9507](https://github.com/elastic/kibana/issues/9507) a +1 or a comment with your requirements, it'll help us prioritize this appropriately. However, you can use the [TSVB](https://www.elastic.co/guide/en/kibana/current/TSVB.html) Table visualization to do this: ![20%20AM](https://us1.discourse-cdn.com/elastic/original/3X/1/5/156829a553db5e22c88fa6dc41fe430a5b33ea56.png) ---
**Author:** ![cgmelastic](https://avatars.discourse-cdn.com/v4/letter/c/b5ac83/32.png) [@cgmelastic](https://discuss.elastic.co/u/cgmelastic)\ **Post date:** [July 24, 2019, 6:08pm UTC](https://discuss.elastic.co/t/possible-to-show-multiple-columns-on-a-data-table/191880/3 "2019-07-24T18:08:43Z")
@Brandon_Kobel That is very cool, that looks like exactly what I need. I have added my +1 to #9705 and started working on a Data Table visualization. Grouping by ID is working, as I see rows, but my Count metrics are giving me 0s: ![57%20PM](https://us1.discourse-cdn.com/elastic/original/3X/e/f/efce6a3cd8002a55d33615ab780bb0bcd43bfff8.png) But if I create a basic Metric and only apply that same filter (`path: "*/reject"`) I can see that there are 11 documents out there that match the filter: ![20%20PM](https://us1.discourse-cdn.com/elastic/original/3X/e/5/e59c68cbbb04948aa6e722ebec1a6e356fd6b8d0.png) What'd I do wrong? ---
**Author:** ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)\ **Post date:** [July 24, 2019, 11:24pm UTC](https://discuss.elastic.co/t/possible-to-show-multiple-columns-on-a-data-table/191880/4 "2019-07-24T23:24:50Z")
Would you mind [creating a bug](https://github.com/elastic/kibana/issues/new?template=Bug_report.md) for this? Even without using the filter, I'm not seeing any results unless I adjust the interval to be larger than the timespan and then tell it to not drop the last bucket. ---
**Author:** ![cgmelastic](https://avatars.discourse-cdn.com/v4/letter/c/b5ac83/32.png) [@cgmelastic](https://discuss.elastic.co/u/cgmelastic)\ **Post date:** [July 25, 2019, 12:07pm UTC](https://discuss.elastic.co/t/possible-to-show-multiple-columns-on-a-data-table/191880/5 "2019-07-25T12:07:01Z")
@Brandon_Kobel , Got it: [https://github.com/elastic/kibana/issues/41969](https://github.com/elastic/kibana/issues/41969) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 22, 2019, 12:07pm UTC](https://discuss.elastic.co/t/possible-to-show-multiple-columns-on-a-data-table/191880/6 "2019-08-22T12:07:03Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.