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

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

Jonkandonkan — Sun, 11 Jun 2023 11:29:42 GMT

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)

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

jthi — Fri, 25 Nov 2022 17:17:30 GMT

You can disable Overlay for the boxplot from Boxplots Variables menu

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

Jonkandonkan — Fri, 25 Nov 2022 20:07:55 GMT

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

jthi — Fri, 25 Nov 2022 20:17:37 GMT

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

Jonkandonkan — Fri, 22 Nov 2024 13:06:59 GMT

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

txnelson — Fri, 22 Nov 2024 13:32:50 GMT

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

Jonkandonkan — Fri, 22 Nov 2024 15:42:41 GMT

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

jthi — Fri, 22 Nov 2024 16:08:12 GMT

You want something like this?

Or this

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

Jonkandonkan — Fri, 22 Nov 2024 16:15:35 GMT

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

jthi — Fri, 22 Nov 2024 16:26:11 GMT

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

Jonkandonkan — Tue, 26 Nov 2024 10:05:20 GMT

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

hogi — Tue, 26 Nov 2024 16:42:12 GMT

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

Jonkandonkan — Tue, 26 Nov 2024 16:37:18 GMT

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

hogi — Tue, 26 Nov 2024 16:46:38 GMT

Actually, a very common issue in JMP - further details can be found here:

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:

... please vote.

The issue could also be solved with a very tiny new feature :
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: