cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!

Discussions

Solve problems, and share tips and tricks with other JMP users.
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 XIII

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:
:folded_hands: 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).

Recommended Articles