Creating delta values plot between two subsets; want to select 2 'tests' to compare among multiple test values

Question

I am plotting CD vs. Depth plot, for total 8 sets in the example (A-a, A-b, B-a, B-b....).For each Test A~D, there are 2 different 'Location' a and b.

I'd like to pick 2 set specifically and create a delta plot; for example, If I select A-a and B-a, CD values are subtracted at each depth and CD vs. Depth plot should be generated.

Is this something I can do at JMP? I was trying to do this in excel using xlookup function, but since the amount of data is huge (30000+ rows) it is just too slow. I am not sure if this something I can do at JMP.

Example data set

Example CD vs. Depth plot;

jthi · Answer

With scripting you can create things like this (this is missing some sanity checks)

Names Default To Here(1);

dt = Current Data Table();
dt << New Column("Group", Character, Nominal, Formula(
	"Test: " || :Test || " Location: " || :Location
));

Summarize(dt, groups = By(:Group));

dt_temp = New Table("TEMPTABLE",
	Add Rows(5), // same as your group size
	Compress File When Saved(1),
	New Column("Depth",
		Numeric,
		"Continuous",
		Values([0, 20, 40, 60, 80])
	),
	New Column("CD First",
		Numeric,
		"Continuous"
	),
	New Column("CD Second",
		Numeric,
		"Continuous"
	),
	New Column("CD diff",
		Numeric,
		"Continuous"
	),
	Invisible
);

update_expr = Expr(
	Try(
		first_group = (lb_first << get selected)[1];
		second_group = (lb_second << get selected)[1];

first_cd = dt[dt << Get Rows Where(:Group == first_group), "CD (nm)"];
		second_cd = dt[dt << Get Rows Where(:Group == second_group), "CD (nm)"];
		dt_temp[0, "CD First"] = first_cd;
		dt_temp[0, "CD Second"] = second_cd;
		dt_temp[0, "CD Diff"] = Abs(second_cd - first_cd);
	,
		dt_temp[0, "CD First"] = [., . ,., ., .];
		dt_temp[0, "CD Second"] = [., . ,., ., .];
		dt_temp[0, "CD Diff"] = [., . ,., ., .];
	);
);

nw = New Window("Demo",
	H List Box(
		Panel Box("Pick First Group",
			lb_first = List Box(groups)
		),
		Panel Box("Pick Second Group",
			lb_second = List Box(groups)
		),
		Data Table Box(dt_temp),
		gb = dt_temp << Graph Builder(
			Size(525, 454),
			Show Control Panel(0),
			Variables(X(:CD diff), Y(:Depth)),
			Elements(Points(X, Y, Legend(11)), Line(X, Y, Legend(13)))
		),
		Panel Box("Actions",
			Lineup Box(N Col(1),
				Button Box("Cancel")
			)
		)
	)
);

lb_first << Set Max Selected(1);
lb_second << Set Max Selected(1);

lb_first << Set Script(update_expr);
lb_second << Set Script(update_expr);

Eval(EvalExpr(
	nw << On Close(
		Close(dt_temp, no save);
	)
));

I think you could also duplicate your table so you can do a self-join with "duplicated" columns, join it to the original table by depth, remove self-joins, create grouping selector, formula for differences and create a plot

And this is easy to automate in JMP.

jthi · Answer

Only scripting options come to my mind (outside of that splitting). I consider JMP tables to be more like database tables than spreadsheet, so the calculations are (usually) done on row level and as aggregations. If the test count is always the same for each of the "pairs" this can be maybe done with a few formula columns and global data filter to make picking options easier.

EdgeMarmoset719 · Answer

I wanted to see if I can quickly change conditions for comparison. It seems that is not as straightforward.

Calculating all the differences would not work since there are so many data set I would think.

Thanks for the help, let me think a bit more.