cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
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.