cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
Phil_Nash
Level II

Axis sort giving odd result

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.

 

JMP Graph.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Axis sort giving odd result

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

jthi_0-1666892984168.png

 

-Jarmo

View solution in original post

4 REPLIES 4
jthi
Super User

Re: Axis sort giving odd result

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)

jthi_0-1666891287716.png

 

-Jarmo
Phil_Nash
Level II

Re: Axis sort giving odd result

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

jthi
Super User

Re: Axis sort giving odd result

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

jthi_0-1666892984168.png

 

-Jarmo
Phil_Nash
Level II

Re: Axis sort giving odd result

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