Extracting the user selected parameters for the X and Y when plotting variability charts
Mar 4, 2016 7:21 AM(2909 views)
Being really new to scripting in jmp. I have a question about this, here is a script that I wrote. What I intend to do is that I have two tables, Table one contains the limits of each test, for example, (keep in mind that the actual table has a few thousand tests, this is just an example)
And the other table (Few thousand columns long) contains the test results
And what I intend to do, is plot a variability chart for the second table for a few selected tests (4 or 5), and I would like the variability chart to autoplot reference lines based on limits from the first table - the upper and lower limit. Now I'm stuck in this situation where I dont know how to complete my script. Currently it looks like this, I can get the reference line to plot at a fixed point at, say "1". But what I want to be able to do is to extract whatever test that the user decides to plot, and extract the limits from the first data table, and plot the limits as a reference line.
Is there a way to extract the user selected parameters (X and Y) of the variability chart, and use that the search for its limits to plot the reference line? As of now, my code looks like this
dt_data1 = Data Table( 1 ); // the Limits table
dt_data2 = Data Table( 2 ); // the actual data table
If you move the limits into the spec limits column property for each of the columns in your measurement data table, from your limits data table, the Variability Chart platform will automatically display the limits.
Here is a script that I wrote recently to answer a posted question on "Importing Control Limits". this script reads from a limits data table and moves it into a measurement data table.
// Before running this script, open up the measurement and limits data tables.
// If you are using the two files I attached to the reply, the dtmeas = and
// dtlim = statements below are pointing to the correct data table. But if
// you use different data tables, you need to change the Data Table names
Names Default To Here(1);
dtmeas =Data Table("Measurements Table");
dtlim =Data Table("Limits Table");
// Split the data table based upon the Grade Code so each group is in a different