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

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:


Is there a better way to do this?


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.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.