Remove line between last point of a curve and 1st point of next curveI 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?
Data Exploration and VisualizationRe: Remove line between last point of a curve and 1st point of next curveThis is the plot I get, which connection is incorrect?
Re: Remove line between last point of a curve and 1st point of next curveI think this was the intention:
Re: Remove line between last point of a curve and 1st point of next curveThen 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 curveso, you want to get these curves into a single graph?
... without the zig-zag lines discussed in Graph Builder. Combine Smoother and Line - how? :
Re: Remove line between last point of a curve and 1st point of next curveThanks 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 curveThanks 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 curvethanks 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 curveGood 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 curveThanks 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 curvereport -> plot window.
select the columns, right click:
