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.



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?