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
Basic Data Analysis and ModelingRe: 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).
Re: How to remove blank inputs on X axis when using graph builder?Starting from this
If you don't mind on missing out of the X-group you can also add both columns to X-axis
You can also use Page and not link X-axis and then move X-axis to "hide" those missing values
There is also a wish list item for this Graph Builder: Option to hide categories with no data
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.
Here is the graph I created on the split data
Note that the X axis for the females does not have a 12 year old category
