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