JMP User Community

Latest Discussions

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

2078 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

1996 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

2364 views | 3 replies
How to take function arguments from a drop down list to use the same argument in a plot

i am creating a drop down list using combo box. the idea is choosing a particular item/option from that list should create a corresponding bar plot. in the attached code, Tool_time_wf is the function that is supposed to create the plot by using the argument/prompt/equipment name[variable choice] from the combo box. Each item/option in the combo box myListbox is already a column name in the data ta...
tonkatsu2020

Discussions |
Jul 23, 2020 10:56 AM

5228 views | 6 replies
Data subset indexing tips

I have a bunch of concatenated test runs output that have columns: time, position, speed, etc. ... and time goes from 0 to some number, e.g. 50, then resets to zero and starts up again. I'd like to make a new column, setid, that indexes the sets, so the first set (time 0-50) gets a "1" in the setid column, the second set (time resets to 0...) gets a "2" in the setid column, etc. Is there a smart/...
BHarris

Discussions |
Jul 23, 2020 10:12 AM

1923 views | 1 replies

Previous
Next

Latest Discussions

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

2078 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

1996 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

2364 views | 3 replies
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

1487 views | 0 replies
bin each row based on date time

I often need to bin each row based on the date time. However, this is kind of troublesome for the data time. let say I am binning based before 7/22/2020 12:00:00pm as Good and after as bad. I can use the IF formula logic to compare the date time to 7/22/2020 12:00:00pm. But to do that I need to convert to the numeric value of 3678264000. if there any quicker way to do this? thanks
wencun6

Discussions |
Jul 22, 2020 3:40 PM

2821 views | 5 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

1487 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

1693 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

1422 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

1288 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

1311 views | 0 replies