# Sorting a whole data table visualization by a Count metric

**URL:** <https://discuss.elastic.co/t/sorting-a-whole-data-table-visualization-by-a-count-metric/116103>\
**Category:** Kibana\
**Created:** [January 18, 2018, 4:47pm UTC](https://discuss.elastic.co/t/sorting-a-whole-data-table-visualization-by-a-count-metric/116103 "2018-01-18T16:47:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![JuanjiJG](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/juanjijg/32/26730_2.png) [@JuanjiJG](https://discuss.elastic.co/u/JuanjiJG)\
**Post date:** [January 18, 2018, 4:47pm UTC](https://discuss.elastic.co/t/sorting-a-whole-data-table-visualization-by-a-count-metric/116103/1 "2018-01-18T16:47:55Z")

</div>

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](https://us1.discourse-cdn.com/elastic/original/3X/0/d/0d8f91f15ba39c0f531f5f86f45b2a4c7a9fea95.PNG)

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

---

<div class="post-metadata">

**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\
**Post date:** [January 18, 2018, 8:55pm UTC](https://discuss.elastic.co/t/sorting-a-whole-data-table-visualization-by-a-count-metric/116103/2 "2018-01-18T20:55:16Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![JuanjiJG](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/juanjijg/32/26730_2.png) [@JuanjiJG](https://discuss.elastic.co/u/JuanjiJG)\
**Post date:** [January 19, 2018, 12:46am UTC](https://discuss.elastic.co/t/sorting-a-whole-data-table-visualization-by-a-count-metric/116103/3 "2018-01-19T00:46:22Z")

</div>

Hi lukas!

I'm using Kibana 6.1.2.

And this is the content of the `uiStateJSON`:

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

```

Thank you so much for your help!

Regards,  
Juanjo

---

<div class="post-metadata">

**Author:** ![JuanjiJG](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/juanjijg/32/26730_2.png) [@JuanjiJG](https://discuss.elastic.co/u/JuanjiJG)\
**Post date:** [January 19, 2018, 10:29am UTC](https://discuss.elastic.co/t/sorting-a-whole-data-table-visualization-by-a-count-metric/116103/4 "2018-01-19T10:29:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 16, 2018, 10:29am UTC](https://discuss.elastic.co/t/sorting-a-whole-data-table-visualization-by-a-count-metric/116103/5 "2018-02-16T10:29:59Z")

</div>

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