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

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

TrimmedJaguar10 — Mon, 04 Nov 2024 22:47:05 GMT

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

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

txnelson — Tue, 05 Nov 2024 03:16:29 GMT

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

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

jthi — Tue, 05 Nov 2024 06:28:01 GMT

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

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

hogi — Tue, 05 Nov 2024 18:14:19 GMT

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

There is a wish from 2022 which already collected 25 (!!) Kudos:
.

The workaround via stacked labels on the X Axis is - indeed - a workaround ; but far from optimal.
along the idea of (@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).