JMP User Community

Latest Discussions

Regex issue with escaped characters

I'm having a problem with regex and bracket characters.This JSL snippet:Show(Regex("abcdef[ghi]", "([^\[]*)\[([^\]]*)\]", "\1{\2}"))doesn't work in JMP (14.1). It gives the following error:Unexpected "([^]*)\[([^\]]*)\]", "\1{\2}"))". Perhaps there is a missing "," or ")". Trying to parse arguments of function "Regex".However, this is valid regex in my Perl regex tester. ( I use Patterns on OS X.)...
john_madden

Discussions |
Nov 26, 2019 3:56 AM

18148 views | 12 replies
Graph Builder: Ticks in Heatmap at center of cells

I want to put the ticks in a heatmap at the center of the cells and not on the grid, which doesn't make sense in my case. I think you'll know what I mean when looking at the graph. The white spaces are incorrect as we measured in x and y at 0, 1.5 and 3 Is there an option somewhere to change the position of the ticks? Thanks @martindemel
JL_LZH

Discussions |
Nov 26, 2019 1:20 AM

3435 views | 2 replies
Formula to average of two cells in a column if a cell is same between rows

I am trying to write a script or formula that will average two cells, at times t and t-1 stored on different rows, if the item ID matches. I think the steps would be as followsIf Item row 2 = Item row 1(value row 2 + value row 1)/2store result in average row 2else leave blank Please see the table below for an example. I put the expected answers in the Average column. I am fine with a scripting ans...
ac527

Discussions |
Nov 25, 2019 9:43 PM

2036 views | 1 replies
95% confidence intervals

Hi All, l am trying to get a summary from a data table, l would like the mean of a variable l10t, the standard error, and 95% confidence interval. It all seemed fairly straight forward, but am having trouble with the 95% confidence intervals, have tried different ways to no avail, currently have dt2<< Summary( Group( :Sample ), Mean( :dilution factor, :l10t ), Freq( "None" ), Weight( "None" ),...
Mickyboy

Discussions |
Nov 25, 2019 9:29 PM

4012 views | 4 replies
JSL to remove virtual join Reference Link?

Does anyone know what the JSL script is to remove a reference link (of a virtual join)?The link below describes the script to create a Link ID and a reference link. I'd like to write a script that reverses that process. https://www.jmp.com/support/help/14-2/virtually-join-data-tables-2.shtml Thanks!
khusodo

Discussions |
Nov 25, 2019 5:59 PM

2045 views | 1 replies

Previous
Next

Latest Discussions

95% confidence intervals

Hi All, l am trying to get a summary from a data table, l would like the mean of a variable l10t, the standard error, and 95% confidence interval. It all seemed fairly straight forward, but am having trouble with the 95% confidence intervals, have tried different ways to no avail, currently have dt2<< Summary( Group( :Sample ), Mean( :dilution factor, :l10t ), Freq( "None" ), Weight( "None" ),...
Mickyboy

Discussions |
Nov 25, 2019 9:29 PM

4012 views | 4 replies
HTTP Request: Post error: InitializeSecurityContext failed: The revocation function was unable to ch

I have an error creating a post request, the error returned is: New HTTP Request() POST [url] schannel: next InitializeSecurityContext failed: Unknown error (0x80092012) - The revocation function was unable to check revocation for the certificate. The solutions here didn't work for me, I got the same error message as HTTP Request with Headers? . My code is approximately: request = HTTPRequ...
bayesfactor

Discussions |
Nov 25, 2019 2:37 PM

5894 views | 2 replies
How to filter / cleanse data JMP using a list [tipp, JSL, scripting]

After receiving so much great support, I thought it was about time I returned this favour. Below you'll find a little program that might make it easier to filter data tables. Hard encoding by "entry" is one way to filter entries; this is tedious and prone to typos. An alternative is to filter entries by their "position" in a filter list. This approach just assumes that the sequence of fields in th...
Newbie2Jumpie

Discussions |
Nov 25, 2019 7:42 AM

2143 views | 2 replies
Predicted Rsquare

I wanted to use predicted Rsquare to test if my model is overfitting or not. I am not really familiar with this, so I have a few questions regarding predicted Rsquare. 1. How much smaller for the predicted Rsquare is a sign of overfitting? If the Adjusted R-square is 0.94, and the predicted R-square is 0.84, is it okay? 2. I don't fully understand how the predicted Rsquare was calcuated. I kn...
CYLiaw

Discussions |
Nov 23, 2019 9:13 AM

3773 views | 2 replies
JMP window groups in windows 10

HI everyone, can anyone help me with the way windows groups instances of JMP in windows 10. In previous versions it seemed to be easier to flick between instances rather than every instance and subwindow being grouped in the taskbar. Has anyone got any suggestions on how to make it better. I find it very difficult to find the actual datatable or plot Im looking to go back to when I have a few open...
barneyonion

Discussions |
Nov 22, 2019 6:41 AM

3787 views | 4 replies

Previous
Next

Latest Discussions

How can I run a .py python script and python scripts compiled as .exe from JMP

Hello, So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...
xxvvcczz

Discussions |
Oct 30, 2019 6:44 PM

1929 views | 0 replies
Analysis of covariance (ANCOVA) for Split plot Design

Hi, I have a problem where I want to do ANCOVA and It is new for me.We have,Main plot data (2 treatments)Subplot data (10 treatments)Yield datawe want to add lodging (%) score as a covariate. How to do it? (I have seen some video tutorial from Youtube but its not easy to understand for me) Your cooperation will be highly appreciated.
Harun-Or-Rashid

Discussions |
Oct 29, 2019 9:03 PM

1298 views | 0 replies
Send Expects Scriptable Object in access or evaluation of 'Send' Error

I create a new window with variability chart, and put into journal. After that i want to save into pdf. But at the last line to save into PDF, it give me error like below. and nothing is saved into pdf. Need some advice which part i am doing wrong? ErrorSend Expects Scriptable Object in access or evaluation of 'Send' , report_R235 << /*###*/SavePDF( "C:\LimTY\NXP\Product\Pegasus\Characterization\...
OneNorthJMP

Discussions |
Oct 10, 2019 8:43 PM

1337 views | 0 replies
Extract Report Data and Export it to Excel

I am totally new to the JMP community and have a limited coding background. I am working with Life Distributions (Weibulls mostly), and I would like to create an Add-in that can do the following tasks once I have selected the best distribution fit: 1. Save specific report data from distribution (see the data tables in red) 2. Export the data into an excel sheet 3. Have the add-in button available ...
jemairsmartes

Discussions |
Sep 11, 2019 10:27 AM

2136 views | 0 replies
How to Add Profit Matrix to Neural Net Confusion Matrix

Hi all, I'm using a neural net to predict whether or not a customer will prefer to buy retail items at a markdown or if they are likely to buy full-price (i.e., "bargain buyers" vs. traditional shoppers). I'd like to incoporate the opportunity cost of a false positive (giving discounts to what would otherwise be a full-price shopper) using a profit matrix, but changing values on the matrix in the ...
GhostBen

Discussions |
Aug 5, 2019 8:00 PM

1375 views | 0 replies