Sort function doesn't seem to work

Get Help
1

I added "count" to sort the data in descend order but the graph doesn't work properly. ( ascend doesn't work properly either) Any way to fix this?

%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE(287)
%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE(287)2085×977 38.3 KB

%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE(288)
%E5%B1%8F%E5%B9%95%E6%88%AA%E5%9B%BE(288)1756×914 28.7 KB

2

Hi @Dan1
The order of stacked bars are different that regular bars, but it's currently not possible to order the stack:
https://github.com/metabase/metabase/issues/7625 - upvote by clicking :+1: on the first post

3

Got it. Thanks a lot！

4

Hi @flamber! I am facing a similar problem. In my stacked bar chart, I am getting this result in the chart legend:
0 1 10 2 3 8 9
instead of
0 1 2 3 8 9 10

reference:
22

5

@Helena That's because you are returning strings instead of numeric values. Computers have a hard time understanding the sorting of string like "1" "10" "2", whereas it can handle "01" "02" "10".
If that doesn't work, then upvote the issue.

1 Like
6

Hi @flamber :slight_smile: thanks for replying me. I used myvariable::INTEGER and it worked.

1 Like