How to order by in a chart?

I want to order by the counts in the Y axis, from the highest to the lowest counts.

@redashgan

I think this is how you can do it currently:

1. use order by in SQL according to how you want to present the data. In this case, order by counts desc
2. In X Axis setting, uncheck sort values and make sure that you use Category for scale.

Hope this works for you.

Thanks so much, uncheck sort values works

I am not sure why using “order by” with checking sort values does not work.
Would values be sorted twice?