JMP User Community

Latest Discussions

JMP Journal adding graphs JSL

Hello Everyone, I have one control chart graph with column switcher on the side to change the graph that I want to look at. I want to be able to use JSL to copy over the control chart to the journal and then use the column switcher to pick a different control chart graph and move that one over too. The point is to be able to move over any of the control chart graphs you want to look at into the j...
rmthomas

Discussions |
Oct 6, 2021 4:45 AM

3383 views | 4 replies
JMP Scripting - New Column Function and Multiple Formula Functions Don't MIX !!!! Interesting Problem !!!!

Hello Community I have written a script in which I search an open data table for rows which contain text A in column 2 AND text B in column 3. Using the row numbers, I then save the text from column 7 for all of those rows to a new individual variable. The problem is I would like to then save the text in column 7 for all those rows in a NewTable with a New Column. The first column was not a p...
SMW

Discussions |
Oct 6, 2021 2:20 AM

1573 views | 2 replies
Concat multiple list items together

Using JMP12.2 - I'm looking for a fast way to concat list items together from two different lists in a 1 to 1 fashion - assuming the lists have the same number of items. This will be used For Each Row in very large tables - so I prefer no iterative function if possible. Here is an example of what I want to achieve: list1 = {"a","b","c","d","e","f","g"};list2 = {"1","2","3","4","5","6","7"}; Accept...
ts2

Discussions |
Oct 6, 2021 1:30 AM

4676 views | 6 replies
Are two regression lines equivalent? ANCOVA versus Fit Line.

I have a data set in which 2 response variables were collected (JO2 and dPsi) under 5 different energy states (dGATP) for subjects on two different diets (PM or SR; grouping variable). I used the Fit Model platform to plot the individual subject data and compare whether a linear or quadratic model would be optimal. The AIC was lower for the linear model for both individual and grouped data and m...
TimboK

Discussions |
Oct 5, 2021 3:05 PM

4415 views | 3 replies
Set a web proxy for New Http Request

I am trying to access a web API using the New Http Request and route the calls via a web proxy. JMP support tells me that proxy settings are set at the OS level or the Environment Variable leves. But my company does not allow changes to the OS or to the environment variables on our issued laptops. Is anyone aware of a workaround that can force New Http Request to route through a proxy serve tha...
tgardner4

Discussions |
Oct 5, 2021 9:18 AM

10348 views | 12 replies

Previous
Next

Latest Discussions

JMP Scripting - New Column Function and Multiple Formula Functions Don't MIX !!!! Interesting Problem !!!!

Hello Community I have written a script in which I search an open data table for rows which contain text A in column 2 AND text B in column 3. Using the row numbers, I then save the text from column 7 for all of those rows to a new individual variable. The problem is I would like to then save the text in column 7 for all those rows in a NewTable with a New Column. The first column was not a p...
SMW

Discussions |
Oct 6, 2021 2:20 AM

1573 views | 2 replies
how to compare rows with 0 and 1 to find out the prevalence and clustering of two medical conditions?

Hello, I am a new and unexperienced user of JMP working on my PhD thesis. I simply cannot find out how to compare a part of my data and I need assistance. My data consists of 146 columns with either 1 or 0 (yes/no) for 146 medical conditions respectively. I have about 14000 rows (patients) to compare this data from. I need to find out the order for the most common combinations for two medical cond...
EmmaLT

Discussions |
Oct 5, 2021 4:31 AM

1859 views | 4 replies
//GraphBuilderGroupBox << Get Window Title issue

Hi, do you know how to get the GraphBuilderGroupBox "name" from the JSL scripting level? In attached picture it would be "Male" or "Female" (marked in red circles). My guess is to have a similar command to << xpath( "//GraphBuilderGroupBox" )) << Get Window Title. However it doesn't work. Here is the code: dt = Open( "$SAMPLE_DATA/Academic Achievement.jmp" ); win = dt << Graph Builder(...
LiPav

Discussions |
Oct 5, 2021 12:54 AM

1460 views | 1 replies
Summary table ignoring weight column in specific conditions (bug?)

For some reason, when adding to summary a Median(), it ignores the weights provided for other statistics. Here, I am creating a simple filter where every male row has 0 weight, hence max and min for males should not exist. Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); // New column: Filter dt << New Column( "Filter", Numeric, "Continuous", Format( "Best", 12 ), Formu...
FN

Discussions |
Oct 4, 2021 11:20 PM

1117 views | 2 replies
Conducting a one-way ANOVA to compare three means?

I have three different data sets (median home values) for the years 2018,2012,2010. I randomly selected a subset of 50 values from each set. How do I compare the mean of these data subsets to each other using a one-way ANOVA? I start off by using the fit y by x tool, but I'm not sure what to put as the y and x to compare the means.
rubio66

Discussions |
Oct 4, 2021 12:59 PM

1358 views | 2 replies

Previous
Next

Latest Discussions

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

946 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

945 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

660 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

1216 views | 0 replies
Projects Window List in JMP 15 for Mac -- Reorder?

I'm trying to use JMP projects more with the promise of re-using graphs and analyses on new sets of similar data. I'm using the Window List in the UL as a kind of 'table of contents' that I can click into to see/show my findings for various analyses. There is a flow to the findings which I'd like to order in that Window List. Is this possible? I can't click and drag an entry for a window up or d...
datanaut

Discussions |
Aug 16, 2021 6:38 AM

611 views | 0 replies