cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
Choose Language Hide Translation Bar
View Original Published Thread

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

Jonkandonkan
Level III

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)

undefined

undefined

undefined

This post originally written in German and has been translated for your convenience. When you reply, it will also be translated back to German.

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