Split columns in a table

Elastic Stack Kibana
1

Hello,
I have some problems creating a table and I hope you can help me.

The relevant part in my documents is a string field and an integer field.
I have a row (bucket) for each string.
I want columns with count for different values of the integer field.

Unfortunately, there's no option to split columns, which is kind of what I want to do. Can filters somehow be added to columns?

2

Not sure if this will work for your use case:

First, split rows using a terms aggregation on your string field. Then, split table (columns) using a terms aggregation on your integer field.

The metric will be count.

3

Thanks for your quick reply.

This gives me several tables next to each other which doesn't look as nice as one table with multiple columns.

4

Right, I should've mentioned earlier: I proposed this as a workaround because AFAIK there's no way to do what you want exactly today. I believe the functionality you are requesting is this: https://github.com/elastic/kibana/issues/5978 (which is a duplicate of https://github.com/elastic/kibana/issues/5049).

5

Alright. So maybe it will be possible in a later version.

Thank you for your help.

6

Hi,
When I did what you offered I got an empty screen and not a split table (multiple tables).

If you can help me it would be great :thumbsup: