Create a ratio in Visual Builder with a numerator that is the count of documents that have a specific filter

[lelwar]

Hello,
Want to make a filter ratio where the numerator and denominator are from different indexes. This works very well with a count when it is only one query for the numerator and the denominator:

response:0 / label:"whatever"

Nonetheless, for example, I am trying to get a ratio where the numerator should be filtered if it fulfills 2 conditions with no luck:

response:0 and store:"whichever" / label:"whatever"

I have also tried to do this with no success by a "group by" of :

response:0 / label:"whatever"

using filter:

store:"whichever"

Is there a better way to do this?

Lel

[Marius_Dragomir]

Only way I would see this possibly working is if you have both indices in the same index pattern. This was ES would treat it as sparse data.