Add a filter in a metric

[vinuja]

I have a system that returns Valid or Invalid Results from different hosts. In a table visualization, I would like to introduce 2 metrics: the count per host and the count of valid per host.
So I create a Data table, with two metrics count and a bucket aggregation for the field "host".

How can I add the filter on the valadation field for the second metric?
I tried JSON scripts but it didn't work.
Thanks
Vinuja

[Bargs]

Hi @vinuja, in the future please ask support questions like this in our Discussion forum https://discuss.elastic.co/c/kibana. We reserve Github for confirmed bugs and feature requests.

That said, I would create a split bar sub-aggregation with the "Filters" agg with one filter value * to match all documents and another filter to match only valid documents. Like this:

If you want the bars stacked side by side like in my screenshot, set the bar mode to "grouped" in the options tab:

If you need additional help, please ask a follow up question in the forums linked above.