cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
sowiakg
Level I

Graph Builder: how do I set a custom name for the X Group?

(JMP 17)

My database has a categorical column that I would like to use as the Group X parameter in my graph. However, that column has a very convoluted name that looks messy when added. I am aware that I can remove it by right click -> uncheck "Show Title", but is there an option to manually set a 'simple' name for that section, similar to naming axes? I can't find such an option in the right-click menus, but perhaps there is a piece of JSL that would work?

Thank you!

Greg

6 REPLIES 6
txnelson
Super User

Re: Graph Builder: how do I set a custom name for the X Group?

If the below is what you are talking about is the graph below, then all that has to be done is to double click on the axis title you want changed and then type in the new value

txnelson_0-1725484801336.png

txnelson_1-1725484841944.png

txnelson_2-1725484886959.png

 

 

 

Jim
sowiakg
Level I

Re: Graph Builder: how do I set a custom name for the X Group?

Thanks for your response! I am looking specifically for X Group. Here is an example:

sowiakg_0-1725491951010.png

Is there any way to change this without changing the column name directly?

Thanks,

Greg

txnelson
Super User

Re: Graph Builder: how do I set a custom name for the X Group?

My first thought is to Create a transform column and then give it a nice short name, and then use it as the X grouping column

Right click in the selection window on the X grouping column you want to use, and select Formula.  Just click on OK.  Then in the selection window, right click on the new transform column and select Rename, then change the name to the nice short name you want to use.

Finally, drag the new transform to the X Grouping drop area.

Jim

Re: Graph Builder: how do I set a custom name for the X Group?

This is why I hate JMP: such an obvious and common need and there is not a way to do it that is not a hassle. 

txnelson
Super User

Re: Graph Builder: how do I set a custom name for the X Group?

One way to channel your anger into an action that might solve your problem would be to go to the JMP Wish List and add your issue to it.

Jim
hogi
Level XII

Re: Graph Builder: how do I set a custom name for the X Group?

Some days ago, at a a JMP users meeting, we discused the issue of 
  Manual axis labels are 'mixed up' when plotting multiple columns 

The story:  For all the other axis labels, it's super easy to change the text.

But it's dangerous when you add new axes to the plot -- the manual axis label will show up at the wrong position.

 

Another user highlighted:
If you have to rename the column in a plot, you do it the wrong way.

Why don't you change the column name?!

 

I disagree - I prefer the tables to be compatible with the input data. This makes it super easy to update the table.

The disadvantage: With this approach, sometimes it's necessary to correct the column names "virtually"  to get a nice plot.

 

I like @txnelson approach with the transform column  

It can also be used as workaround for the above problem.

 

Another approach:

🙏 Column Property: Column Name Alias 

Allow secondary or alternate column names 

I hope the wishes will collect enough kudos to make it into JMP 19 ...