How to order by in a chart?


#1


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


#2

@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.


#3

Thanks so much, uncheck sort values works


#4

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