cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
JZ
JZ
Level I

How to change orders of grouping in graph builder?

As shown in the attached picture, right now the "After" group is showing in front of the "Before", which doesn't make sense. How can I swap them? Tried sorting the Group column by Descending in the data table but didn't work. 

4 REPLIES 4
txnelson
Super User

Re: How to change orders of grouping in graph builder?

To do this, what you do is to cjange the Value Order Column Property for your postan_jrlengh grouping column.

 

The easiest way to do this is to go to the header for the postan_jrlength column, and then right click and select "Value Order".

 

JMP will then use the order specified for the order

Jim
Victor_G
Super User

Re: How to change orders of grouping in graph builder?

Hi @JZ,

 

Welcome in the Community !

In order to solve this problem, you can try to add in your "Group" column a "Value Order" property.

To do this, right-click in your "Group" column name, click on "Column Properties" and then "Value Order" :

Victor_G_0-1706039727106.png

You can then in the new window indicate the order of the categories :

Victor_G_2-1706039807668.png

And this ordering will be kept in the graph builder :

Victor_G_3-1706039861196.png

 

Hope this answer will help you,

Victor GUILLER
L'Oréal Data & Analytics

"It is not unusual for a well-designed experiment to analyze itself" (Box, Hunter and Hunter)
jthi
Super User

Re: How to change orders of grouping in graph builder?

Using Value Order column property is the preferred method and should be used, but there is other method. You can create new column, which will then have for example 1 for before and 2 for after. Then you can use Order By on the x-groups

jthi_2-1706125924473.png

jthi_1-1706125907187.png

jthi_3-1706125945586.png

 

 

 

-Jarmo
hogi
Level XII

Re: How to change orders of grouping in graph builder?

Since Jmp 17, there is even another option:

If you just want to change the order for one plot - or use different orders in different plots: right click/Configure Levels:

hogi_0-1706141856168.png

then change the order:

hogi_1-1706141933745.png