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

 

 

 

 

13 REPLIES 13
Jonkandonkan
Level III

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:

Jonkandonkan_0-1732615513335.png

 

hogi
Level XII

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

e

Jonkandonkan
Level III

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

 

Jonkandonkan_0-1732638865971.png

 

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

 

Jonkandonkan_1-1732638984005.png

 

 

hogi
Level XII

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.

hogi_0-1732639430412.png

 

 


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