[Lens] Allow filters to be generated from the results of a query, like "greater than 95th percentile"

[wylieconlon]

This is a use case that came up in the context of multi-pass aggregations, but I recently saw a request in the forums for this same kind of query. We do not need to wait for Elasticsearch feature to implement this, as it can be orchestrated from Lens using the expression pipeline.

The feature should consist of:

1. The ability to define aggregations that run before the rest of the visualization
2. A form input or text box that lets you convert the aggregation results into a query

Example use cases:

• Find the 95th percentile of response_time with an aggregation, and then visualize the geographic locations with unusually high times.
• Find the most common term in the dataset, and the filter for this term only
• Find the most recent 500 IDs and use that as a filter, like this discuss question

[elasticmachine]

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

[stratoula]

Maybe something we can explore with ESQL, I like this as an idea :)

[timductive]

This can be done now either with Lens formula or ESQL