Sorting Kibana filters aggregation


#1

I have created a filters aggregation in Kibana in a data table. For every filter element, I have an associated aggregated count. However, I cannot find a way to sort the data table by the counts for each filter.

Is there a way to do this or is it not possible at the moment?


(Joe Fleming) #3

Maybe I'm not understanding what you're using for your filter aggs, but sort the data in the table seems to work for me. Is this not what you mean?


#4

You can indeed get the correct order in the table by sorting that column. However, I would like this order to be persisted so that the visualisation can be put in a dashboard with that specific order.

A way too keep the table sorted by a certain column would also do fine, but the order in that table is reset every time the table is refreshed as far as I know.


(Joe Fleming) #5

Ah, I see what you mean. Persisting user interaction (ie. clicking on the columns and sorting the data, and keeping it sorted that way) had been planned for a while, and has now been completed and merged. I believe shipped in the last alpha release of 5.0.

Unfortunately, I don't believe there are any plans to backport that to the 4.x series.


#6

Great that it will be possible in Kibana 5. Seems like a very useful feature to me.

I would have happily tried out Kibana 5, but it is not feasible at the time to setup an ES 5 cluster as well, which unfortunately is required.
Thanks for your answers.


(system) #7