nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Setting Spec Limits using Column Data

Austin

Hi,

I have a query that produces a data table with parameter test results and spec limits listed in different columns (example below). Is there a script that can set the spec limits to each parameter? Would I need to rearrange my data table for this to work?

Sample ID	Parameter	LSL	USL	Result
Sample 1	Parameter 1	5	10	6
Sample 2	Parameter 1	5	10	7
Sample 3	Parameter 2	1	4	3
Sample 4	Parameter 2	1	4	2
Sample 5	Parameter 3	10	20	15
Sample 6	Parameter 3	10	20	18

Thanks!

Accepted answers

tonya_mauldin

You can accomplish this in the Process Screening platform without having to rearrange your data. Here is a blog post that talks about this. Process specification limits that differ based on a grouping column - JMP User Community You can find examples of scripting Use Limits Table in the Object Scripting Index.

All comments

txnelson

Spec Limits are saved as column properties in a data table. Only one set of spec limits can be saved for each column. Therefore, you will have to separate your parameters, (i.e. Parameter 1, Parameter 2) as independent columns for each of the samples, (i.e. Parameter 1:Sample 1, Parameter 1:Sample 2)

There is a built in Spec Limit Manager that can help you populate the column properties. It is available at:

Analyze=>Quality and Process=>Manage Spec Limits

See Tonya's comment below

tonya_mauldin

Austin

Thank you!