Enhanced table vizualization to allow agregation and drill drown

[filou711]

Describe the feature: We create a table visualization(like enhanced table in kibana) at a certain level of granularity. We click on a line, and we want to see other lines appears, that compose the details of the initial line. The goal is to do drill drown to a more detail granularity. If we go back, the table show the initial line.

Describe a specific use case for the feature: Imagine, we have these data:

• A list of data per country.
• Country are aggregate in a column "COUNTRY GROUP"

-I want to first, see value at "COUNTRY GROUP" level

-If I click on a COUNTRY GROUP, like A, the details appears with 1 line per country of A group country:

-If we go back, the table show the initial table at country group level.

-If I do it in kibana enhance table, I'm able to have the granularity at the country group level . But I cannot have the details per country. If I want to have the details per country, I have the table below. But I'm not able to have the granularity per country group on the same table.

So the goal is begin at the granularity of country group level (A or B). And per click, go and see details per country inside a country group.

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[markov00]

In order to provide better transparency of priorities, issues that will not be prioritized within the next 24 months are being closed.

Tracking request in Lens general improvements ice box https://github.com/elastic/kibana/issues/184459