# How to get data split by columns in Data table visualization while using "filters" in sub-aggregation

**URL:** <https://discuss.elastic.co/t/how-to-get-data-split-by-columns-in-data-table-visualization-while-using-filters-in-sub-aggregation/154040>\
**Category:** Kibana\
**Created:** [October 25, 2018, 3:56pm UTC](https://discuss.elastic.co/t/how-to-get-data-split-by-columns-in-data-table-visualization-while-using-filters-in-sub-aggregation/154040 "2018-10-25T15:56:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![chetang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chetang/32/3451_2.png) [@chetang](https://discuss.elastic.co/u/chetang)\
**Post date:** [October 25, 2018, 3:56pm UTC](https://discuss.elastic.co/t/how-to-get-data-split-by-columns-in-data-table-visualization-while-using-filters-in-sub-aggregation/154040/1 "2018-10-25T15:56:18Z")

</div>

Hi,

I am trying to build a data table visualization which will provide data with "filters" sub-aggregation in different columns in a single file.

When I use "Split Table" within buckets, I get as many files as the number of filters.

 ![kibana_merging_tables_question](https://us1.discourse-cdn.com/elastic/original/3X/e/3/e36c50ba4f863f34d5235066a7cc69bdc663deed.png)

When I use "Split Rows", it gives me data in a single file, which is what I want, but I want them in different columns not in different rows.

 ![kibana_merging_tables_question2](https://us1.discourse-cdn.com/elastic/original/3X/b/c/bc2727f68ce235fcff6b1d75e9d93b2f5d54c608.png)

How can I get this in different columns like this?  
|SHAPE |RDC1 |RDC2 |RDC3 |RDC4 |  
|0022princess|2400 |2501 |2475 |2492 |  
|0025round |21132|21612|21068|21448|

---

<div class="post-metadata">

**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\
**Post date:** [October 25, 2018, 6:55pm UTC](https://discuss.elastic.co/t/how-to-get-data-split-by-columns-in-data-table-visualization-while-using-filters-in-sub-aggregation/154040/2 "2018-10-25T18:55:18Z")

</div>

This isn't possible with the data table at the moment (see [https://github.com/elastic/kibana/issues/9585](https://github.com/elastic/kibana/issues/9585)). However, you could use the heat map with labels enabled as a possible workaround:

 ![52%20PM](https://us1.discourse-cdn.com/elastic/original/3X/c/4/c40d60caeb70f4733d41ea077f9bb28d33ead5af.png)

---

<div class="post-metadata">

**Author:** ![chetang](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/chetang/32/3451_2.png) [@chetang](https://discuss.elastic.co/u/chetang)\
**Post date:** [October 26, 2018, 8:24am UTC](https://discuss.elastic.co/t/how-to-get-data-split-by-columns-in-data-table-visualization-while-using-filters-in-sub-aggregation/154040/3 "2018-10-26T08:24:57Z")

</div>

Hi Bargs,

I am using Kibana Version 4.6.6 and I don't see any heatmap option while creating visualization. Also, I doubt heatmap will be a help as I need this for lots of data (around 30k buckets), that's why I was looking for data table option.

Any suggestions to it using data-table!

Also, the issue that you have linked talks about Pivot Table as visualization. Is this already out in newer version of Kibana?

---

<div class="post-metadata">

**Author:** ![Bargs](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bargs/32/5429_2.png) [@Bargs](https://discuss.elastic.co/u/Bargs)\
**Post date:** [October 29, 2018, 4:55pm UTC](https://discuss.elastic.co/t/how-to-get-data-split-by-columns-in-data-table-visualization-while-using-filters-in-sub-aggregation/154040/4 "2018-10-29T16:55:40Z")

</div>

Ah sorry, the heatmap vis was added in version 5.2.

Unfortunately the data table simply can't do this yet, even in the newest versions of Kibana. [This issue](https://github.com/elastic/kibana/issues/3620) might be even more relevant for you. The best advice I can give is for you to add a comment or a 👍 to those issues to express your interest.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 26, 2018, 4:55pm UTC](https://discuss.elastic.co/t/how-to-get-data-split-by-columns-in-data-table-visualization-while-using-filters-in-sub-aggregation/154040/5 "2018-11-26T16:55:46Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.