cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Browse apps to extend the software in the new JMP Marketplace
Choose Language Hide Translation Bar
TrimmedJaguar10
New Member

How to remove blank inputs on X axis when using graph builder?

When using the Graph Builder, I am adding to the "data result" to the Y-axis, the "serial number" to the X-axis and then I am grouping X by Part Number.

 

Basically, I want to compare the results of two different parts, with the data organized by Serial Number.

 

However, as you can see on the photo, I cannot get JMP to stop display blank data.  Basically, it has the Serial Numbers from the other part number as part of the label on the X-axis.  You can see that PN 789101 SN 190A123156 shows on the X axis on the PN 123456 as blank, and visa-versa for the other part number.

 

Basically, on the "123456" side of the graph I only want data from PN 123456 to show, and visa versa.  How can I do this?

 

Software: JMP 18.0.0

1 REPLY 1
txnelson
Super User

Re: How to remove blank inputs on X axis when using graph builder?

You will need to split the data by Part Number into 2 separate columns and then add the 2 part numbers on the X axis, side by side.

Then add your Y column.  In my example below, I also added in a reference line after the highest level of the first X axis column.

Using the Big Class data table, with all of the 12 year old females removed, I split by the Sex column.

txnelson_0-1730776451387.png

Here is the graph I created on the split data

txnelson_1-1730776522310.png

Note that the X axis for the females does not have a 12 year old category

Jim