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

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

EdgeMarmoset719 — Tue, 11 Feb 2025 20:44:44 GMT

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;

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

jthi — Tue, 11 Feb 2025 20:59:24 GMT

With scripting this can definitely be done and maybe also without scripting at least as a workflow. Can you provide example dataset and can you only pick two pairs at the same time? Also is the location always same for selected tests?

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

EdgeMarmoset719 — Tue, 11 Feb 2025 21:10:47 GMT

Sure, here is the example data file.

I am looking to get the delta value between two pair, so yes I'd always pick 2 for comparison.

Location may not be the same, in the real data set I have some samples that have more locations. I also need to compare sample to sample as well as location to location. For instance, sample A-a to sample C-b

Here is

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

jthi — Wed, 12 Feb 2025 05:46:59 GMT

Is it OK if new data table is created after user selections? My basic idea would be with scripting:

Add ordering column to your data
Create UI in which user can pick from list box which combinations to compare
User presses OK and new table will be created with data for those two combinations
Difference will be calculated
Visual the data

Other option that comes to my mind is to split the data and pre-calculate all the differences into columns. Then you could use Column Switcher in graph builder to change which to compare.

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

EdgeMarmoset719 — Wed, 12 Feb 2025 22:50:45 GMT

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.

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

jthi — Thu, 13 Feb 2025 05:47:13 GMT

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.

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

jthi — Thu, 13 Feb 2025 18:53:09 GMT

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.