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

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.