cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
Jonkandonkan
Level III

Connect dots in boxplots by ID (row order?) in Graph Builder

Hi

I'm trying to connect individual data points in a repeated measures in graph builder. Using row order, it seems it makes two lines (i.e. from the left box, one line to the middle and one line to the right box) I just want one connecting from left-middle-right!

Using ID as overlay, it gets correct (Pic 2). But then I can't do the box plots correct? (Pic 3)

 

Jonkandonkan_0-1669396034659.png 

Jonkandonkan_1-1669396141371.png

Jonkandonkan_2-1669396167898.png

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: Connect dots in boxplots by ID (row order?) in Graph Builder

You can disable Overlay for the boxplot from Boxplots Variables menu

jthi_1-1669396642097.png

 

 

-Jarmo

View solution in original post

13 REPLIES 13
jthi
Super User

Re: Connect dots in boxplots by ID (row order?) in Graph Builder

You can disable Overlay for the boxplot from Boxplots Variables menu

jthi_1-1669396642097.png

 

 

-Jarmo
Jonkandonkan
Level III

Re: Connect dots in boxplots by ID (row order?) in Graph Builder

Great, thanks. Is there an easy way to harmonize the color, i.e. make all lines same color (without changing every line individually)? 

jthi
Super User

Re: Connect dots in boxplots by ID (row order?) in Graph Builder

Immediately one idea comes to my mind... create new nominal column with same value and then set same value to each of rows and use that column as the color (you can disable that from box plot if you want to). The value you will choose will show in legend but you can easily hide it if you want to by unchecking it

 

jthi_0-1669407440006.png

 

-Jarmo
Jonkandonkan
Level III

Re: Connect dots in boxplots by ID (row order?) in Graph Builder

Having trouble with this again...

 

 Repeated measures, two different groups. I want to connect the dots for the same ID, but from the left dot/boxplot, one line goes to the middle box and one to the right. Instead of one going from left-to-right. Can't seem to get it right. Shouldn't be a line connecting the two groups either..

Jonkandonkan_0-1732280715033.png

 

txnelson
Super User

Re: Connect dots in boxplots by ID (row order?) in Graph Builder

Not knowing what your data table contains, and what settings you have specified in Graph Builder makes it tough to come up with a solution for you.

Providing a sample data table, would be helpful, along with an image of the graph along with the full control panel from Graph Builder.

Jim
Jonkandonkan
Level III

Re: Connect dots in boxplots by ID (row order?) in Graph Builder

This is the setup (I've always had this problem with JMP, never solved row order graphs!).

Stacked data (3 datapoints per ID (setting A/B/C), two groups (A/B). 

 

I would like to make a graph with mean SD, or a boxplot, with individual data points. 

 

Sample dataset provideed. 

 

Jonkandonkan_0-1732289911589.png

Jonkandonkan_1-1732290067956.png

 

 

jthi
Super User

Re: Connect dots in boxplots by ID (row order?) in Graph Builder

You want something like this?

jthi_0-1732291542406.png

Or this

jthi_1-1732291680901.png

 

-Jarmo
Jonkandonkan
Level III

Re: Connect dots in boxplots by ID (row order?) in Graph Builder

I would like to do graphs like this. Connected dots. Change-plots with individual lines, in this case three repeated measures. 

 

 

Jonkandonkan_3-1732292081268.png

 

 
 

 

jthi
Super User

Re: Connect dots in boxplots by ID (row order?) in Graph Builder

Could you provide dataset with such repeats? If I understand your data correctly you don't have any repeats in it

jthi_1-1732292719403.png

 

-Jarmo