topic Re: Axis sort giving odd result in Discussions

Axis sort giving odd result

Phil_Nash — Sun, 11 Jun 2023 11:28:50 GMT

I tried to sort the X-Axis by descending values.. but it's clearly not doing that. What am I missing? INV$ is the Y-axis. I want most INV$ to least by label on the X-axis.

Re: Axis sort giving odd result

jthi — Thu, 27 Oct 2022 17:21:50 GMT

Without knowing the data you have, only one thing comes to my mind. Check which summary statistic is being used (you might have to change it to Sum for example)

Re: Axis sort giving odd result

Phil_Nash — Thu, 27 Oct 2022 17:25:58 GMT

I do have the summary statistic set as sum, which is why it's odd.

Re: Axis sort giving odd result

jthi — Thu, 27 Oct 2022 17:50:54 GMT

Check Order Statistic from the X-axis (right click on axis and check order statistic). It might be using different summary statistic than the bars for ordering.

Example: Bars are using Sum but X-axis is sorted by Min

Re: Axis sort giving odd result

Phil_Nash — Mon, 31 Oct 2022 13:25:24 GMT

That did it! The order statistic was Mean.. so I changed it to Sum and it worked as expected. Appreciate the help.