Sorting a whole data table visualization by a Count metric

Hello everybody!
I have a question regarding Kibana and its visualizations.
I have a data table visualization with several buckets, all of them ordered by a Count metric. The table shows all the columns, including the Count one.
I would like to save the visualization but by default, sort all the entries by Count in descending order:


I couldn’t get the visualization saved with the Count filter applied by default, and every time I load the table, I have to click a couple of times in order to get it sorted.
Is there any way I could save a visualization with this setting applied?
Thank you so much for reading me.
Regards,

Juanjo

What version of Kibana are you using?
If you open the corresponding saved object in Management, can you copy and paste what you see in uiStateJSON? Thanks!

Hi lukas!
I’m using Kibana 6.1.2.
And this is the content of the uiStateJSON:

"uiStateJSON": "{\"vis\":{\"params\":{\"sort\":{\"columnIndex\":null,\"direction\":null}}}}"

Thank you so much for your help!
Regards,

Juanjo

Hi again lukas,
I finally figured it out. I have to edit the uiStateJSON property in order to get the column sorted.
Thank you so much for your help!
Regards,

Juanjo

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