[Lens] Allow metric visualization to drill down

[ghudgins]

Describe the feature:
Allow a user to configure a lens metric vis to drill down passing an exists filter for the selected metric (and including any global filter state)

Describe a specific use case for the feature:
When I see a metric is not performing well on a dashboard
And I have a separate "drilldown dashboard" that details a single metric's performance holistically
I need to create a drill down from the metric overall to a target dashboard
So I can investigate "all" of something without breaking it down

[elasticmachine]

Pinging @elastic/kibana-vis-editors @elastic/kibana-vis-editors-external (Team:VisEditors)

[elasticmachine]

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

[flash1293]

@ppisljar I think we discussed this a while back - based on the current structure this would not only affect Lens but also other visualization types. What do you think about rolling out this change? It would basically mean adding a createFilter for all the existing metric aggs which is just creating an exists filter on the used field (if applicable, e.g. count wouldn't get one). It would also make sense in the context of filtered metrics (those get the filter defined for the metric)

[ppisljar]

@flash1293 something worth setting up a poc branch so ppl can play with it.

also, the issue talks about drilling down, which could be achieved by adding a drilldown link to the panel, but it won't add an exists filter to the target dashboard. cc @vadimkibana is something like this possilble with drilldowns at the moment if we would add filtering capacity to metrics ?

[flash1293]

also, the issue talks about drilling down, which could be achieved by adding a drilldown link to the panel

I think it's about clicking the metric itself, not opening the context menu.

[jsanz]

As reported in our forum, it seems there is a regression and single metrics can't be used on drilldowns or to set up an "exists" filter.

This is happening for both the legacy and the metric types. On the other hand, when the metric is split, the drilldown is available.

Also, #147148 is reporting something similar.

(Checked in 8.11.4-SNAPSHOT and 8.10.4)

[stratoula]

They are not supported if the metric is count of records, it should be supported if it is a count of a field. This happens because drilldowns are tied to the filters and clicking a count metric doesnt provide a filter.

[prakashgupta1605]

Hi,
It seems like your drilldowns are tied to filters only but it should still allow the user to drilldown or navigate to another dashboard on clicking a single metric.
Please think from user's perspective. Many of the users are having a simple requirement that if they click on a single metric, it should allow you to navigate to a detailed dashboard.
We are having a home page dashboard where we are having multiple single metric visualizations from different datasets and we want to provide an easy navigation to the users. One of the options is to display markdown visualization with all the links but directly clicking on metrics is the most user friendly.
You must be having a technical challenge but if you think from user's perspective, its an issue in the drilldown feature that it works with filters only.

[stratoula]

@prakashgupta1605 I agree with you! I think it makes sense to allow drilldowns not tied to the filters. But with the current implementation and functionality this is not a bug.

I will discuss the enhancement request with the presentation team and I will create an issue.

[prakashgupta1605]

Another point. As per the elastic documentation, the drilldown should work for Vega visualizations as well. Could you please help me how do I make the drilldown work in Vega.

[prakashgupta1605]

@stratoula Thanks for understanding. Could you please share the issue once its created.
Also I would like to bring your attention that there are many users those who got confused with this feature. They just want to click and navigate to a detailed dashboard.
Many other visualization tools are having this feature as a very common use case and unfortunately its not available in Kibana. So, please take it on priority.

[Heenawter]

Thanks so much for the feedback, @prakashgupta1605!

Have you seen the new Links panel made available in 8.11? It sounds perfect for your use case! We created this panel specifically with dashboard navigation in mind.

At least for now, we do not have a plan to allow for drilldowns without filters, since this goes against what drilldowns are meant to be used for - specifically, drilldowns are designed to carry vis-specific context across dashboards so that data is narrowed / drilled down on (hence the name) as the user navigates. The links panel, on the other hand, gives the author control over what context is carried over from dashboard to dashboard, and it does not add any vis-specific context like drilldowns do.

Please let us know if this does not work for you 🙇