JMP User Community

Latest Discussions

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
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

3676 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

1409 views | 1 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

976 views | 0 replies
Auto Scaling of Variability Chart Y-axis based on USL & LSL spec limit

When there is outlier data, my chart is always being scaled to mix or max point, which make the chart not visible.Is that possible to use JSL script to set the Variability Chart Y-axis dynamically based on the parameters USL & LSL limit that already embeded inside the parameters? Please advice. Thanks
OneNorthJMP

Discussions |
Jul 23, 2020 7:10 AM

19809 views | 15 replies

Previous
Next

Latest Discussions

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
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
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

2018 views | 5 replies
How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

For example, according to "Big class.jMP"
1. First, categorize by age.
2. Determine the minimum "weight" >90 for each age.
3. Figure out the number of age categories that meet the second condition.So it turns out the number of ages is 3. How can I use JSL to solve it quickly?Thanks!
lwx228

Discussions |
Jul 22, 2020 3:25 AM

1378 views | 3 replies
Autocorrelation by JMP14

I check my training powerpoint file I was trained on year 2007. When we want to make control chart, we have to check normality of data. And also autocorrelation by JMP. I try to search autocorrelation check on JMP14 but I cannot find it. Any function in JMP14 to use instead of autocorrelation.

In the previous version of JMP we need to go by Autocorrelation Check – In JMP:Analyze > Modeling > Tim...
ThoYala

Discussions |
Jul 21, 2020 10:38 PM

3687 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