JMP User Community

Latest Discussions

Filter data within date and time range

Hi. I would like to filter data within 2 dates. the dates are in another table. Table 1: Table 2:How can I filter the data in table 1 that has END_TIME between the START_TIME and END_TIME in table 2?I want the result in the new table. Hope I explained it clearly. Thank you.
thoufik11

Discussions |
Oct 7, 2021 9:30 PM

2143 views | 1 replies
Help with writing a loop in JSL

I need to download the data that is available through a url: http://www.arpalazio.net/main/aria/sci/basedati/chimici/BDchimici/RM/MedieGiornaliere/RM_PM2.5_2019_gg.txt To download the data for different years, I need to change the year in the url, as shown in red. I would like to write a loop in JSL that runs through the years from 1990 to 2021 and put the data in a table. I am new to JSL so any h...
shasheminassab

Discussions |
Oct 7, 2021 2:04 PM

3058 views | 6 replies
White bar on top of charts?

Hello, I've producing charts with this script. In some cases, a white bar appears on top of the charts (see screenshot, left chart). Does anyone know how I can get rid of this white bar? Thank you, Bordini
bordini

Discussions |
Oct 7, 2021 2:01 PM

2010 views | 4 replies
Using list of columns in formulas

I ran into an "problem" when trying to directly use a column list returned from the column dialog (for example {:sex, :age: name}). When I try to use that list directly in Col formulas (Col Mean, Col Sum...) with byVars the formula won't work correctly. Using the list with for example Sum() formula works fine. Is this intended behaviour and does anyone have cleaner ways to build Col Sums from list...
jthi

Discussions |
Oct 7, 2021 12:04 PM

2279 views | 2 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

826 views | 0 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
"^" 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

989 views | 1 replies
Sheet result of fit parametric survival: how to know if a parameter is protective or deleterious?

Dear CommunityI have performed a fit parametric survival analysis in a cohort of patients.I’m able to identify in the sheet results that several characteristics are statistically associated with the survival.However, I’m not able to identify whether these characteristics are protective or deleterious.May you please indicate me how to find this information in the sheet result?Thank you very muchWit...
Titanescu

Discussions |
Oct 6, 2021 11:51 PM

1300 views | 2 replies
JMP DOE Setting a range for my factors

Hello, I am new to JMP and am trying to create a simple DOE where I am trying to maximize growth in a reactor by using different agitation rates, thus my agitation is my factor and my growth is my response. My issue is whenever I try to make a custom DOE I can not set a range for my factors, all there is are values and whenever I make my DOE it just uses the two values I entered. I want to set an ...
cgagnon

Discussions |
Oct 6, 2021 7:24 AM

2887 views | 4 replies
correlation diagram with motor severity score Y using a graph builder by adjusting biomarker A according to age and gender

We would like to clarify whether there is a linear relationship between biomarker X(DATQUANT) and motor severity score Y (MDS-UPDRS 3 total score) in patients with a neurological disorder. In a simple correlation, biomarkerX is associated with motor severity score Y.Since age and biological sex influence the biomarker X, we considered them as covariates. At that time, I am thinking of creating a...
KF2

Discussions |
Oct 6, 2021 5:04 AM

1958 views | 3 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

976 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

963 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

1238 views | 0 replies