Sorting a whole data table visualization by a Count metric

Elastic Stack Kibana
1

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:

discuss
discuss.PNG1483×446 39.7 KB

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

2

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!

3

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

4

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

5

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