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

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

3 REPLIES 3
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
jthi
Super User

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

Starting from this

jthi_1-1730787776303.png

If you don't mind on missing out of the X-group you can also add both columns to X-axis

jthi_2-1730787785912.png

You can also use Page and not link X-axis and then move X-axis to "hide" those missing values

jthi_5-1730787943424.png

 

jthi_4-1730787915771.png

 

There is also a wish list item for this Graph Builder: Option to hide categories with no data 

 

-Jarmo
hogi
Level XII

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

One of the most wanted features - and still missing in JMP.

There is a wish from 2022 which already collected 25 (!!) Kudos:
🙏 X group: restrict the values on the axis to the respective group .

 

The workaround via stacked labels on the X Axis is - indeed - a workaround ; but far from optimal.
along the idea of Plenary: All Graphs Are Wrong, but Some Are Useful   (@XanGregg ), it's amazing how much a graph can help the viewer understand the message if it separates the Variants (X Group) from some subcategories (on the X axis).