[Lens] Allow cell contents to be clickable when drilldowns are enabled

[wylieconlon]

This is an idea proposed by a discuss user to have the entire table cell be a clickable area, instead of having a set of action icons on the side.

[elasticmachine]

Pinging @elastic/kibana-app-services (Team:AppServices)

[elasticmachine]

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

[ghudgins]

"i'm trying to get the same interaction the customer has in [a legacy tool]"

+1

[flash1293]

Copied from #137274

Today, if a drilldown is added to a Lens table, it's added to one of the "row" columns but sometimes the "row" column is added (and hidden) just to decide which field to group on. We would like to be able to decide which column (from rows/colmns/metrics) should show the drilldown.

A real example:
We group a list of Kibana instances by their UUID, but we want to use the display name instead of the UUID and connect the drilldown to this column instead.

[flash1293]

Copied from #137273

Today, if a drilldown is added to a Lens table then you have to hover over the main cell, click the little plus and then follow the pop up menu.

For users who are more familiar with Dashboards that might feel natural but it is fairly different from the common UX in Kibana custom UIs, like this recently build Infrastructure Metrics Table, where each row has a link to the details page.

We would like to be able to make drilldowns accessible either as cell links or whole row links.

[flash1293]

An easy way to implement a version of this:

• add a new property to each dimension: “Click to filter”
• If enabled for a column, no filter in/out cell actions are shown, instead the whole cell is clickable and the “filter in” action will get dispatched