JMP User Community

Latest Discussions

Loop through the check boxes to get the values

Hi All,I want to generate an overlay plot using my script. The plot is overlaid by the “Device_Type” column in my data table. However, I would like to let the user choose which device type they want to include in the overlay plot. Therefore, I want to create a list of checkboxes in the user interface. Here is my code: Close All( Data Tables, NoSave );//close all previous windows dt1 = Open("data_d...
hahahaqing

Discussions |
Jul 25, 2020 12:17 PM

2664 views | 4 replies
How to create Oneway from two different columns (without stacking)?

Hello. It is probably a trivial question (I'm very new to JMP). I have ~300 columns in a file and want to compare means and stdvs of only two of columns of interest using Fit Y by X (Oneway analysis), how can I do it easily without stacking? - I basically had to stack all of the data, create a new jmp. file and only then I was able to generate what I need (see below). Thank you,Alex.
Alex19

Discussions |
Jul 24, 2020 2:00 PM

2030 views | 5 replies
image in a background of a graphbuilder

hi, is it possible to put an image in the background of a graph?Let me explain: I have a graph with histograms representing a % of failures for a process;I would like to overlay with an image of a process screen. I will size the graph so that the histograms are well placed on the image. thanks fro your answers. all the best
Françoise

Discussions |
Jul 24, 2020 8:00 AM

3418 views | 5 replies
Referencing columns from other tables

I'm trying to make a new table by reading from two source tables. I'd like to avoid joining them into one big table and manipulating from there. The new table will be an array of deltas between the two source tables. The script is creating the columns just fine, but it's not populating them with anything. I'm assuming there's some syntax i'm missing in referencing columns from other tables in ...
bwkeller2

Discussions |
Jul 24, 2020 7:47 AM

3520 views | 7 replies
JMP 15 date time format changes

Hi,I upgraded to JMP15 recently and found that some of my scripts written in JMP14 did not work properly. I found that this line did not work because of an unrecognized format:New Column( "Date", Numeric, "Continuous", Format( "d/m/y h:m:s", 22, 0 ), Input Format( "d/m/y h:m:s", 0 ) ), When I changed it to read:New Column( "Date", Numeric, "Continuous", Format( "d-m-y h:m:s", 22, 0 ), Input Forma...
Onjai

Discussions |
Jul 24, 2020 6:24 AM

5087 views | 7 replies

Previous
Next

Latest Discussions

Referencing columns from other tables

I'm trying to make a new table by reading from two source tables. I'd like to avoid joining them into one big table and manipulating from there. The new table will be an array of deltas between the two source tables. The script is creating the columns just fine, but it's not populating them with anything. I'm assuming there's some syntax i'm missing in referencing columns from other tables in ...
bwkeller2

Discussions |
Jul 24, 2020 7:47 AM

3520 views | 7 replies
How to make Col List Box Report only specific data type

try to make a column list box so the user can select parameters for analysis. Want to limit to column with data type "character" in this col list box. Use the script below but it report all columns. nw = new window("Select Parameter for Pareto", borderbox(left(3),top (2), hlist box( textBox("Select Group for Yield Analaysis"), hlistbox( vlistbox( panelbox("Select group", C...
yanee

Discussions |
Jul 23, 2020 6:21 PM

1862 views | 3 replies
Screening Outliers

Hello, I have some data that has outliers. I was able to find them using Explore Outliers. I selected only 1 column of data and another categorical one to group by. I used the Quantile Range Outliers command, and one outlier was detected. I'd like to color or select that cell. When I choose one of the options, I get a JMP Alert: "Select a column or columns before clicking this button". How ...
natalie_

Discussions |
Jul 23, 2020 1:10 PM

1483 views | 2 replies
DSD question on Blocking at 4 blocks vs 3 blocks

Hi,Designed a DSD experiment with 5 factors in JMP15. Can only run 4 conditions at a time. So added 4 blocks with center runs to estimate quadratic effects. Expected a design with 4 conditions per block and a total of 16 conditions. Instead, block 1 & 2 have 5 conditions, and block 3 & 4 have three conditions. Tried to repeat or play around the setting still cannot get 4 conditions per block....
mng1

Discussions |
Jul 23, 2020 1:05 PM

1268 views | 2 replies
Column Custom Formula

I would like to add a new column 'Vth' in my table with the following calculation:-First I need to find the index i of column 'Id' where the 'Id' is nearest to 1e-6; and then Vth = Vg(i). It should be grouped by Mod and Device columns as well. That is, each unique combination of Mod and Device will have one Vth value. IdVgModDeviceVth2.00E-0631AX1 2.00E-072.81AX1 2.00E-082.61AX1 2.00E-092.41AX1 2....
pankajsync

Discussions |
Jul 23, 2020 12:57 PM

1603 views | 3 replies

Previous
Next

Latest Discussions

XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

976 views | 0 replies
Using JMP to Calculate Surface Flatness

Has anyone used JMP to calculate the Minimum Zone surface flatness of a point cloud? I have some differences between two metrology areas for our surface flatness requirements and wanted to check them in JMP. There are different algorithms for doing the calculation. (There is an ASME standard for the general rule, ASME Y14.5: " a tolerance zone defined by two parallel planes within which the surfa...
jay_holavarri

Discussions |
Jul 20, 2020 11:26 AM

1271 views | 0 replies
Save all scripts and close reports by JSL

Trying to write a script for this I found the following below working. JMP15@Win10.The first part opens two tables and starts some Reports,and the second Closes all report Windows post saving scripts to belonging tables.But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference).Is there a way to find proper reference for e...
Georg

Discussions |
Jul 20, 2020 7:48 AM

1123 views | 0 replies
[JSL Contour Plot] Method of define contour plot, number, minimum, maximum

The contour plot is very helpful to show 3D map, however the problem of defining the zone is always a trouble. In my typical jsl plot, I use something below to define the contour plot zone number = 8, maximum = 1.4, minimum =1. However, the table column :Length may change time to time, and the scale will have to be modified manually for each corresponding plot. Does someone have experience how t...
Stokes

Discussions |
Jun 25, 2020 12:09 PM

983 views | 0 replies
Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

945 views | 0 replies