How to get terms from two indices with worst ration?


(Yannick Gladow) #1

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:
.es(q'name:Test',index='index1',metric='count).divide(.es(q'name:Test',index='index2',metric='count'))

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?

thanks,
yannick


(Brandon Kobel) #2

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


(system) #3

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