573631_en-US

liliconcom

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)

Data Exploration and VisualizationWindowsRe: Connect dots in boxplots by ID (row order?) in Graph Builder

You can disable Overlay for the boxplot from Boxplots Variables menu

 

 

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)? 

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

 

 

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..

 

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.

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. 

 

 

 

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

You want something like this?

Or this

 

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. 

 

 

 

 

 

 

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

 

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

The same ID has repeated measurements in three different conditions, A - B and C. 

It's in stacked/tall format. Would you like it it in wide for this? I don't see how that would work. It's not specific for this dataset, in general I want to to graphs with repeated measures that connects via a line.. Wheter its  2 (pre-pst), 3 or more repeates.

e.g:

 

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

e

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

In my caase, putting ID as overlay gets me closer (and not using row order). Then, unclick overlay for those elements not needed; in this graph only for the line. But this messes up coloring (and one have to change every line individually?). 

 

 

If i'm putting in a dot with meanSD instead of a bar chart, this messes up alignment..

 

 

 

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

Actually, a very common issue in JMP - further details can be found here:
Graph Builder. Combine Smoother and Line - how? 

The easiest trick:
Disable Overlay for any of the other plots, just use it for the line graph.

 

Bsisedes that, some plots can be fixed by setting Overlay Encoding to NONE
and using the Color Drop Zone  in addition to control the colors.

 

 

↑ for new JMP users (keep the plot as simple as possible)
__________________________________
↓ for more advanced users who have to create more complicated plots

 

If you want to create

- Bar Graphs with stacked / side by side option

- multiple smoothers in addition to line graphs

- grouped Box plots

... you have an issue.

THE solution for this issue and many others:
Graph Builder - Overlay by multiple columns 
... please vote.

 

The issue could also be solved with a very tiny new feature :Graph Builder: Line - possibility to add breaks 
The idea: For line graph, an option to remove all lines which run from right to left.

 

a workaround proposed by  @XanGregg :

Hide the the backwards line segments by assigning their own legend color:
https://community.jmp.com/t5/JMP-Wish-List/Graph-Builder-Line-possibility-to-add-breaks/idc-p/799851/highlight/true#M6408 
The benefit of Color compared to Overlay:
it is less "expensive", in JMP 19, you an use up to 20 (?) columns as color : )
On the other had, just one column can be selected as Overlay :  (
which brings us back to:
Graph Builder - Overlay by multiple columns