JMP User Community

Latest Discussions

Combining models

If I learned one thing from Discovery Summit Americas this year, it was how common it is to average and/or create ensemble models, something I had heard about but never considered (being a modeling novice). So I decided to do it. Making an ensemble model is easy; I saved the model as a prediction formula and simply included that as a predictor in the next round of model screening (using JMP Pro 16...
abmayfield

Discussions |
Oct 8, 2021 9:56 AM

1958 views | 3 replies
data cleanup, merge data from 3 columns into one column

HI Newbie here, I need some help to merge the data from 3 columns into one column, the data were collected in different time and by different person, and in 3 columns, so there are some missing data, some matched, like this: A B C 1 1 0 01 1 How do I merge the data in A, B, C columns into one column in JMP?Thank you so much for helping!
TonyS

Discussions |
Oct 8, 2021 9:32 AM

2722 views | 6 replies
How to Assign Date Values based on a Current Month Key

I have data from a data base that assigns a column for the Current Month number when the data gets pulled, and then creates separate columns for previous months counting back. So for a 24 month data pull from September, there will be a column "Current Month" that has the value "9" for all rows, then it will have 24 columns with subscript header "_01", "_02", ..."_24", which denotes "Aug 2021", "Ju...
Mo

Discussions |
Oct 8, 2021 6:19 AM

1616 views | 2 replies
need to close an open plot window

Hi - I am using JMP 12.1 and trying to use script to close an open plot window after it displays for about 5 seconds. I am using the following script but it is not working. (I am new to scripting and unfortunately am not finding the answers I need in the JSL index - probably user error(!) - but so far it has not been very intuitive or simply has not had the information I'm looking for.) ....fit...
learning_JSL

Discussions |
Oct 8, 2021 6:13 AM

1513 views | 2 replies
Import Excel with Macro formula

I have an issue here: When importing an Excel file which contains Macro based formulas, these cells only yield missing values instead of their actual values. How can I import this data correctly? Note: I assume that the values are stored in the Excel file, similar to the values of normal formula cells, because when I open the file in Excel with deactivated macros, the values are well present. Here...
JWi

Discussions |
Oct 8, 2021 4:53 AM

6942 views | 9 replies

Previous
Next

Latest Discussions

Combining models

If I learned one thing from Discovery Summit Americas this year, it was how common it is to average and/or create ensemble models, something I had heard about but never considered (being a modeling novice). So I decided to do it. Making an ensemble model is easy; I saved the model as a prediction formula and simply included that as a predictor in the next round of model screening (using JMP Pro 16...
abmayfield

Discussions |
Oct 8, 2021 9:56 AM

1958 views | 3 replies
Import Excel with Macro formula

I have an issue here: When importing an Excel file which contains Macro based formulas, these cells only yield missing values instead of their actual values. How can I import this data correctly? Note: I assume that the values are stored in the Excel file, similar to the values of normal formula cells, because when I open the file in Excel with deactivated macros, the values are well present. Here...
JWi

Discussions |
Oct 8, 2021 4:53 AM

6942 views | 9 replies
Column filter for graph builder (Parallel plot)

The local data filter allows the user to select the rows of interest. I wonder how I can allow the same functionality but for columns without having to edit the graph. For example, allowing the user to select what to visualize between weight, size, age, sex... Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); Graph Builder( Size( 490, 448 ), Show Control Panel( 0 ), Varia...
FN

Discussions |
Oct 8, 2021 1:15 AM

882 views | 1 replies
JSL: Saving multiple chart and auto fit each of them into 1 page

I have created a Window with V List Box which contained multiple Variability Charts and tried to save them into 1 pdf. What i want to achieve is saving and auto scale each of the Variability Charts into 1 single page of pdf. Can anyone help to advise how to do that? Much appreciated!nw = New Window( "taskQueryCharzCurrent - Variability Chart of current", V List Box( Variability Chart( Y( :cu...
giin

Discussions |
Oct 7, 2021 6:42 AM

799 views | 0 replies
"^" next to P-value

Hello,After running a custom design, the symbol " ^ " appears next to the P-value of some 2nd order variables.What does it mean? Does it mean that the variable alone has less influence on the answer than the 2nd order factor ?Thanks
Fredix

Discussions |
Oct 7, 2021 2:27 AM

953 views | 1 replies

Previous
Next

Latest Discussions

JSL: Saving multiple chart and auto fit each of them into 1 page

I have created a Window with V List Box which contained multiple Variability Charts and tried to save them into 1 pdf. What i want to achieve is saving and auto scale each of the Variability Charts into 1 single page of pdf. Can anyone help to advise how to do that? Much appreciated!nw = New Window( "taskQueryCharzCurrent - Variability Chart of current", V List Box( Variability Chart( Y( :cu...
giin

Discussions |
Oct 7, 2021 6:42 AM

799 views | 0 replies
Skip Lot Sampling Plan

Hi,I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://www.itl.nist.gov/div898/handbook/pmc/section2/pmc27.htm I appreciate any help you can provide. Thanks Adam
AT

Discussions |
Sep 10, 2021 10:38 AM

943 views | 0 replies
Time values in xls or xlsx, csv, and JMP

Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time column together to create a date time column. To analyze the data, I use JMP so I am importing the excel file.However, I ran into a number of oddities:1. When I import multiple files (from customers to ...
fliew0410

Discussions |
Sep 7, 2021 7:25 AM

943 views | 0 replies
Error while using Azure MFA to connect with JMP

I have rightly set up the ODBC connection version 17 for SQL server using Azure MFA. However, when I try to connect for the DSN via JMP i get the following error. how to overcome this error in JMP14. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Password option must not be specified, if Authentication option is 'ActiveDirectoryInteractive'.
hariharan249

Discussions |
Sep 3, 2021 7:14 AM

655 views | 0 replies
Applying Boolean Logic to filtering/selecting records in a Dashboard/Application built from multiple platforms

Hi everyone, I've been working on a systematic map to accompany a literature review on forest bird habitat relationships that is getting much closer to completion. A hearty shout out to community members @cwillden , @txnelson , @danschikore , @brady_brady , and technical support crew Adam Morris, Sarah Seligman, Laura Archer, and Wendy Murphrey for helping me get this project this far along. I f...
caseylott

Discussions |
Aug 17, 2021 11:15 AM

1214 views | 0 replies