topic Re: Remove line between last point of a curve and 1st point of next curve in Discussions

Remove line between last point of a curve and 1st point of next curve

Claire — Tue, 10 Feb 2026 19:18:07 GMT

I have 4 variables - let's call them X, Y, sweep and batch.

X and Y are numerical continuous, sweep and batch are numeric nominal.

I want to plot XY line curves, per sweep and batch.

The data looks like:

X Y sweep batch

0.10 0.20 1 1

0.11 0.30 1 1

0.15 0.36 1 1

0.12 0.22 1 2

0.13 0.31 1 2

0.14 0.29 1 2

0.09 0.2 1 3

0.12 0.33 1 3

0.11 0.31 1 3

0.14 0.24 2 1

0.10 0.34 2 1

0.11 0.30 2 1

0.13 0.21 2 2

0.16 0.22 2 2

0.18 0.33 2 2

0.12 0.21 3 3

0.17 0.27 3 3

0.19 0.29 3 3

I use the overlay for sweep and color for batch.

The graph puts a line between my last point of a (sweep,batch) to the 1st point of the next (sweep,batch).

I think in jmp17, this was resolved by clicking 'Row order' but no luck with jmp18.

Can someone help, please?

Re: Remove line between last point of a curve and 1st point of next curve

jthi — Tue, 10 Feb 2026 21:13:53 GMT

This is the plot I get, which connection is incorrect?

Re: Remove line between last point of a curve and 1st point of next curve

miguello — Tue, 10 Feb 2026 22:00:24 GMT

I think this was the intention:

Re: Remove line between last point of a curve and 1st point of next curve

hogi — Wed, 11 Feb 2026 04:00:02 GMT

so, you want to get these curves into a single graph?

... without the zig-zag lines discussed in :

Re: Remove line between last point of a curve and 1st point of next curve

hogi — Wed, 11 Feb 2026 15:09:50 GMT

Then indeed, @miguello 's approach is the key - just activate row order() to get the lines right:

Graph Builder(
	Transform Column( "Concatenate[sweep,batch]", Character, Formula( Char(:sweep) || "_" || Char( :batch ) ) ),
	Variables(
		X( :X ),
		Y( :Y ),
		Overlay( :"Concatenate[sweep,batch]"n, Overlay Encoding( "None" ) ),
		Color( :batch )
	),
	Elements( Points( X, Y ), Line( X, Y, Ordering( "Row Order" ) ) )
);

In addition:

For sorted data (with ascending X values per trace)

dt << Sort(By( :sweep, :batch, :X ));

there will be a cool new setting in JMP20: Row Ascending
https://community.jmp.com/t5/JMP-Wish-List/Graph-Builder-Line-possibility-to-add-breaks/idc-p/929879/highlight/true#M8256

-> It makes it really easy to generate plots like this:

Graph Builder(
	Variables( X( :X ), Y( :Y ), Overlay( :batch ) ),
	Elements( Points( X, Y ), Line( X, Y, Ordering( "Row Ascending" ) ) )
);

Re: Remove line between last point of a curve and 1st point of next curve

Claire — Wed, 11 Feb 2026 15:05:45 GMT

Thanks jthi for your help - I'll reply to the latest comment - to you / miguello and hogi

Re: Remove line between last point of a curve and 1st point of next curve

Claire — Wed, 11 Feb 2026 15:08:22 GMT

Thanks miguello for your help - you are correct - your plot is close to what I wanted (but I wanted sweeps in solid/dots/dashed and batches in different colors to differentiate the type of variables) I'll reply to the latest comment - to you / jthi and hogi

Re: Remove line between last point of a curve and 1st point of next curve

Claire — Wed, 11 Feb 2026 15:34:32 GMT

thanks all for the prompt help - much appreciated.

Altogether, I did not want to concatenate cols because there are lots of cols I'm grouping by to visualise the impact (I like looking at raw data 1st). If I add empty rows for the data, keeping batch and sweep filled, your solution works perfect.

My tables have ~10M lines though, I guess I need to get scripting. Pity there is no tick a box anywhere to discontinue the curves, would be much better than have to add thousands of lines to my tables...

Re: Remove line between last point of a curve and 1st point of next curve

hogi — Wed, 11 Feb 2026 15:55:11 GMT

Good news: you don't have to add any column to the data table.
In the report, select 100 columns - right click - concatenate. That's it.

Re: Remove line between last point of a curve and 1st point of next curve

Claire — Wed, 11 Feb 2026 16:33:57 GMT

Thanks hogi - with in the 'report' do you mean in the 'table' - I'm not finding the 'concatenate' - apologies not that agile in JMP

Re: Remove line between last point of a curve and 1st point of next curve

hogi — Wed, 11 Feb 2026 17:55:41 GMT

report -> plot window.
select the columns, right click: