Allow filtering of individual metrics

[gregboero]

It would be nice, if individual metrics could be filtered down individually.
This could be achieved by letting the user attach filters and/or queries to a metric, which Kibana would then compile into a filter aggregation which will be wrapped around the metric aggregation.

The original issue talked about allowing this via the JSON input, but I think the actual feature wish here is to filter down individual metrics, so this issue has been rewritten to reflect the actual intent not the implementation, since we want to keep it open, since it already has some upvotes.

Old issue

Describe the feature:
in a visualization it would be nice if we could use the Advanced JSON Input to reduce (filter) the aggregation
by example :

[fightfate]

any progress ?

[wylieconlon]

While I don't think we would do this using the "advanced JSON" input, I think this is becoming a priority for us in Lens as well #67228

[elasticmachine]

Pinging @elastic/kibana-app-arch (Team:AppArch)

[cjrobbertse]

+1 filtering of metric in table visualization is exactly what we need

[ranitg]

is this going to be added?