Sort by total X axis


I want to visualize using a stacked bar chart.
My need is to sort according to total X axis data. If you use sort by from count + group by, the results are like this. How can I achieve these needs?

I use metabase v0.44.2 and v1.47.1.

thanks before.

my expectation is the 11264 is second, and 9000 is third

if you have a premium token, please write to help at metabase dot com

sorry, I don't have premium tokens. any other way?

Is it a Question or a Native query?

If it happens to be SQL, I can try to help troubleshoot.

this is happens in Question :frowning:

Okay, I think I have an idea for you. You can create a custom column in your Question:

Then use the custom column to sort:

Then turn off that column in the visualization: