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

[chetang (Chetan Gupta)]

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.

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.

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|

[Bargs (Matt Bargar)]

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

[chetang (Chetan Gupta)]

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?

[Bargs (Matt Bargar)]

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 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.