Split columns in a table

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?

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.

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.

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

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

Thank you for your help.

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: