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