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?
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 on the first post
Got it. Thanks a lot！
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
0 1 2 3 8 9 10
@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.
Hi @flamber thanks for replying me. I used myvariable::INTEGER and it worked.