I want to be able to find the ratio of times each value in a certain field existed.
currently to achieve this I have to build a separate series with manual filters on each value.
what i would assume should be possible (as possible in timelion) is to group by the terms on the field, and then the ratio will be for each term divided by the OVERALL numebrs.
Today this doesn't seem possible, because I have to add a specific query.
Please help
@Nathan_Reese - thanks for responding, but this isn't what i'm looking for.
If we take your example, what I would like to know is what percent of the destinations each airline has flights to.
So the metric is cardinality on destination, and the group by is on Terms-Carrier, but there is no logical way to give the Numerator to be "carrier:relevant carrier from terms aggregation" and denominator to be "All". This is possible in timelion and is something i would assume can be possible here.
You can set TSVB to display things as a percentage of the subtotal, which should do what you are looking for. It's the second example in this post: ## What is the ratio of each delay type over time? https://www.elastic.co/blog/how-to-display-data-as-a-percentage-in-kibana-visualizations
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.