JMP User Community

Latest Discussions

JMP Tabulate by list of column names in JSL

Hello, I have table and I want to tabulate it by column "student", column "subject" and column "class" but column "Subject" and column "class" is not necessary to available in the data.If it has column "subject" but not column "class" then it should tabulate by column "student" and column "subject".If it has column "class" but not column "subject" then it should tabulate by column "student" and co...
Rajat

Discussions |
May 13, 2020 6:06 AM

5464 views | 6 replies
Creation of a new column based on grouping of other columns

Hi All,I am trying to create a new column "Status" which will return "Active" or "Replaced" based on the following specification (attached part of the table with "Status" column as illustration of expected result). Each TOOL and Site can replace different Sub_Tool during time and runs several units with its time stamp. The most recent Sub_Tool for the specific Tool and Site should receive Active ...
DZ_932

Discussions |
May 13, 2020 2:56 AM

17311 views | 5 replies
points and lines in a graph

hi, how to do so that the points are not slightly offset ? best regards
Françoise

Discussions |
May 12, 2020 11:35 PM

5252 views | 5 replies
Difference between two Cpk analysis tool

Hi all, I have generated random data from Johnson Sl distr. and saved it in a column. Now, when I use these two Cpk analysis tolls, I get diff. results:1. Analyze> Quality and Process> Process capability2. Analyze> Fit > Capability analysis (I have tried all of the options for long term, moving range, ...)For both method I chose Johnson Sl distr. and the same USL.So, how come I get diff. results? ...
mkhoddam

Discussions |
May 12, 2020 10:27 AM

5849 views | 9 replies
Evaluation of the existing model

Hi All,I had created a predictive model and recently my colleagues at QC had to change one of their ingredients, which is one of the many variables in the model, to continue batching their products. I want to evaluate the existing model instead of fine-tuning it because there is not enough data yet and changing it will lower the accuracy. They have new measured responses, using the new ingredient,...
Amir_H

Discussions |
May 12, 2020 8:46 AM

5911 views | 7 replies

Previous
Next

Latest Discussions

Creation of a new column based on grouping of other columns

Hi All,I am trying to create a new column "Status" which will return "Active" or "Replaced" based on the following specification (attached part of the table with "Status" column as illustration of expected result). Each TOOL and Site can replace different Sub_Tool during time and runs several units with its time stamp. The most recent Sub_Tool for the specific Tool and Site should receive Active ...
DZ_932

Discussions |
May 13, 2020 2:56 AM

17311 views | 5 replies
Difference between two Cpk analysis tool

Hi all, I have generated random data from Johnson Sl distr. and saved it in a column. Now, when I use these two Cpk analysis tolls, I get diff. results:1. Analyze> Quality and Process> Process capability2. Analyze> Fit > Capability analysis (I have tried all of the options for long term, moving range, ...)For both method I chose Johnson Sl distr. and the same USL.So, how come I get diff. results? ...
mkhoddam

Discussions |
May 12, 2020 10:27 AM

5849 views | 9 replies
Evaluation of the existing model

Hi All,I had created a predictive model and recently my colleagues at QC had to change one of their ingredients, which is one of the many variables in the model, to continue batching their products. I want to evaluate the existing model instead of fine-tuning it because there is not enough data yet and changing it will lower the accuracy. They have new measured responses, using the new ingredient,...
Amir_H

Discussions |
May 12, 2020 8:46 AM

5911 views | 7 replies
Concatenate strings to create variables within a formula

Hi, beginner JMP user here, I would like to create a new column "Tag Range" which has the formula in it "Tag.ULIMIT-Tag.LLIMIT". Tag.ULIMIT and Tag.LLIMIT are columns in my data table. I can create the column by explicitly defining the column names in the formula as below, but I would like to replace these with the variables "UpperLIMIT" and "LowerLIMIT". (ultimately, I would like to run a script ...
spudton

Discussions |
May 12, 2020 5:41 AM

2784 views | 1 replies
Tabulate configuration support

Hi, I'm trying to create new score card for our group,the score card seems to work great, I just wanted to add the option for the user to have only the first grouping columns (:owner), and if he press on a relevant button then the net grouping column will appear (:buckets), is their an option to do it?also, it seems that the ROUND() function does not work in this setting, any other option?thanks f...
Hamal22

Discussions |
May 12, 2020 4:21 AM

2231 views | 3 replies

Previous
Next

Latest Discussions

How do I have two different chart types in a single graph using two axis?

While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot? Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot. To do this, first clear the row s...
Bass_Masri

Discussions |
Apr 28, 2020 4:28 PM

4787 views | 0 replies
How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

2261 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

2061 views | 0 replies
Running script from command line on MAC

Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I have this but it only opens the file unless I have the "//!" open -g -W -a /Applications/JMP\ Pro\ 15.app/ $(pwd)/myscript.jsl
vince_faller

Discussions |
Jan 10, 2020 2:26 PM

1688 views | 0 replies
how to add confounding variable

I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomous). 3- Y variables: insurance and practice (dichotomous) and time (continuous)I have one confounding variable Age (continuous). I will have to add random effect to X variable. But I am confused how to add confounding variable to this analysis. Can an...
billi

Discussions |
Jan 6, 2020 9:39 AM

1624 views | 0 replies