Is it possible to create subcolumns in kibana?

[sudhanva]

I have the following json objects in my elasticsearch index:

{
    "model": "toyota",
    "color": "red",
    "transmission":"auto"
}

{
    "model": "toyota",
    "color": "green",
    "transmission":"auto"
}

{
    "model": "tesla",
    "color": "red",
    "transmission":"auto"
}

{
    "model": "tesla",
    "color": "red",
    "transmission":"manual"
}

I would like to create a table that counts the number of vehicles with the specified properties as follows from this data:

Is this possible?

[weltenwort (Felix Stürmer)]

Hi @sudhanva,

unfortunately not, but this is a feature that is requested frequently, e.g. in https://github.com/elastic/kibana/issues/9585 and https://github.com/elastic/kibana/issues/3620. The targeted solution to both would be the pivot table, which is tracked in https://github.com/elastic/kibana/issues/5049. Please feel free to add your use case to the issue to give our visualizations team a better picture of the requirements. Thank you!