topic Control display of box plot / points in grouped chart based on data label in Discussions

Control display of box plot / points in grouped chart based on data label

skratchzero — Wed, 03 Apr 2024 18:58:48 GMT

I have some data that I want to display in a specific way with some box plots and can't figure out how to get the result I'm looking for. I have measurements of a parameter at four locations, let's say Location 1, Location 2, and Location 3. The measurements are done on three different types of parts, let's say A, B, C. I have a huge population of data from parts of Type A at Location 1 and Location 2. I have a very small amount of data for parts of Type B and C (one of each), at all three locations 1, 2, 3. Here is what I want to do:

Show only boxes for Type A at Location 1 and Location 2
Show only points for Type B and C, at all Locations

So in JMP, I have three columns: Data, Location, and Type. Using Graph Builder, I set Data to Y, Location to X grouping, and Type to Color. I enabled points and box plot, and set the transparency of the points for Type A to 0. This has me 99% of the way there. Now I'm just stuck on how to remove the box at Location 3.

Bonus points: In this case it's not a big deal, but ideally I would like the boxes to not be calculated using the B and C data. The only way I can think to do that is to split A off into its own column but then it overall seems more cumbersome.

Re: Control display of box plot / points in grouped chart based on data label

txnelson — Wed, 03 Apr 2024 22:13:07 GMT

My suggestion is to split your data for each of the locations into separate columns, and then drag the 3 columns on to the graph, rather than using an X Grouping.

Re: Control display of box plot / points in grouped chart based on data label

hogi — Wed, 03 Apr 2024 22:47:35 GMT

Use Transparency = 0 to hide the red box plot(s) *)

*) it will also remove the red box plots from Location 1&2:

Red box plots @ location 1&2?
Actually there should be some - and they appear when you use Type as overlay.
If you use Type as color, the single box plot will include all kinds of types (!): A,B C.

And to align the points and the box plots:
use Box placement: aligned

Re: Control display of box plot / points in grouped chart based on data label

skratchzero — Thu, 04 Apr 2024 00:12:57 GMT

When I use Type as Overlay, the transparency of the box and point is linked (selecting either the box or the points of the Type automatically selects the other). Did you have to do anything to change their transparencies independently?

Edit: Right clicking without left clicking first seems to do the trick. Let me double check this ends up working correctly and then I'll accept the answer.