JMP User Community

Latest Discussions

Box size of Graph builder plot

Is there a way I can specify box size for a graph builder plot? See highlighted image below. Box size does not include the axis label sizes. I want to make multiple plots with same box size. Frame size considers the size of the whole frame and not the box.
pankajsync

Discussions |
Oct 10, 2021 2:39 AM

4398 views | 5 replies
Open Files in Directory based on a List of Variable Filenames

Hi all, I have a list of filename. This list of filename is variable and change from to time. I want to match these file name to the files available in a directory. If match , open the files. I write below code and run it. It does not work.Need guidance here. folder = "C:\savefile\"; filename ={"Jan", "Feb", "Mar"}; filelist= Files In Directory(folder); For(i=1, i<= N items(filename), i++,...
bzanos

Discussions |
Oct 9, 2021 6:29 PM

2548 views | 4 replies
Stepwise Show Formula Change

Hello I am fairly new to JMP, I created a stepwise and saved my probability formula. It shows my formula answers for Lin(no), Prob(no), and Prob(yes), is there any way to get it to show me Lin(yes). I need it to actually show up on the data sheet aswell.
mbauriem

Discussions |
Oct 9, 2021 10:50 AM

916 views | 1 replies
Screening designs - How do we know if the effects are not significant or if the whole data is not good (significant variation) without doing replicates?

To show robustness of a chemical process, we often need to show regulators that selected parameters (temp, equivalents, time and reagent ratios) are not impacting the quality (purity) of final product. In order to show this, regulators prefer performing screening designs. Usually, we want to show that the parameters do not have detrimental effect within the ranges studied, so that the process is...
jmpkat

Discussions |
Oct 9, 2021 10:44 AM

4835 views | 10 replies
Value Ordering in JMP Script by a Variable

Hello all,In my data set I will be using a column, called Set, as my x-axis variable in a barchart. I want them to be sorted in the order from smallest response value to largest response value so I have bars that are increasing in length. For example if I have the following data:Set ResponseA 5B -7C 10I would want the order in the barchart to be B, A, C. Obviousl...
mjbauer

Discussions |
Oct 9, 2021 6:57 AM

20243 views | 7 replies

Previous
Next

Latest Discussions

Box size of Graph builder plot

Is there a way I can specify box size for a graph builder plot? See highlighted image below. Box size does not include the axis label sizes. I want to make multiple plots with same box size. Frame size considers the size of the whole frame and not the box.
pankajsync

Discussions |
Oct 10, 2021 2:39 AM

4398 views | 5 replies
Stepwise Show Formula Change

Hello I am fairly new to JMP, I created a stepwise and saved my probability formula. It shows my formula answers for Lin(no), Prob(no), and Prob(yes), is there any way to get it to show me Lin(yes). I need it to actually show up on the data sheet aswell.
mbauriem

Discussions |
Oct 9, 2021 10:50 AM

916 views | 1 replies
Screening designs - How do we know if the effects are not significant or if the whole data is not good (significant variation) without doing replicates?

To show robustness of a chemical process, we often need to show regulators that selected parameters (temp, equivalents, time and reagent ratios) are not impacting the quality (purity) of final product. In order to show this, regulators prefer performing screening designs. Usually, we want to show that the parameters do not have detrimental effect within the ranges studied, so that the process is...
jmpkat

Discussions |
Oct 9, 2021 10:44 AM

4835 views | 10 replies
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

1999 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

7024 views | 9 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

826 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

977 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

965 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

691 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

1240 views | 0 replies