Sort by total X axis

setya · October 3, 2023, 10:24am

hello,

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

Luiggi · October 3, 2023, 2:57pm

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

setya · October 4, 2023, 1:32am

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

addison · October 9, 2023, 7:17pm

Is it a Question or a Native query?

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

setya · October 18, 2023, 1:26am

this is happens in Question

addison · October 18, 2023, 3:45pm

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: