How to get terms from two indices with worst ration?

Hey I am trying to create a visualisation of the terms with the worst ratio of appearing in two indices.

Basically I have documents in two indices with a name field, now I want to be able to see the names where the count in index 1 / count in index 2 percentage is the lowest.

I see how I could do this in timelion for individual names:

This gives me the exact ratio for the queried name, but I need to get all the names, for which this ratio is the lowest.
Trying to split at name fails, as I can not divide by another split series.
Could I get this visualisation with a different approach / visualisation tool?


@yannick-cw there isn't currently a way to do calculations on the documents in two different indices in Kibana.

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