I am using the VSB to build a chart that uses a Filter Ratio aggregation, with Metric Aggregation set to the default Count. I am also grouping by a term.
This works perfectly fine for Top N, but for all other visualisations (namely Gauge in my case) the ordering is random, I get lots of values visualised which shouldn't even be part of the set (they contain only the denominator value).
The Order By only allows to select Doc Count (Default). The Top N is sorted properly but the other visualisations are not. How can I sort the other visualisations properly?
My Kibana version is 6.0.0.