JMP User Community

Latest Discussions

Script for Control Charts (all numeric Columns) with saved Limits in one table

Hi, I'm trying to generate one Window/Report with several Control Charts (all numeric columns of the data table). So far I was able to generate this report. But I'm not able to save all Limits in one data table. Can anybody help me? Following my codedt = Current Data Table (); //Deselection von allen Spalten cols = dt << get column names(); For(i = 1, i <= N Col(dt), i++, cols[i] << set selec...
mkennke

Discussions |
Jun 28, 2017 2:50 AM

8349 views | 3 replies
[Script] Color Gradient Output

R1=(dt<< Tabulate(
Show Control Panel( 0 ),
Show Tooltip( 1 ),
Add Table(
Column Table( Statistics( N )),
Column Table( Grouping Columns( :Name( "TEST" ) ), Statistics( Row %, N )),
Row Table( Grouping Columns( :Radius ) )
)
)) << Make Into Data Table;R1:"N(1)"<< Set Property( "Color Gradient", {"White to Orange", Range( {0, 547, 187.945945945946} )} )
<< Color Cell by Value;
R1:"N(8)"<< Set Property( "Colo...
kuanaunwei

Discussions |
Jun 28, 2017 12:57 AM

10915 views | 10 replies
Wildcard selection of characters from a given file name

Hello,I am trying to look up certain characters from a file name and select those file.for eg: file name: HELLO123_MT_XYZ, Code:For( i = 1, i <= N Items( files ), i++,If( Contains( files[i], "MT" ), //Enter search criteria from file nameOpen( files[i] );));Above code with "MT" will pull all file names with MT as character. But how can i select files with wild card? for eg: *123*XY*
CG

Discussions |
Jun 27, 2017 11:19 AM

12813 views | 8 replies
Distribution analysis (e.g. summarize statistics) direct calculation after selection?

Dear all,
I´m sure its an easy question - so for you I think its an quick and easy answer :)

I would like to calculate the data in the distribution-overview based on the selection:

Here for example I would like to see the summary statistics direct after selecting this data (new table calculation). For now I just can see this specific calculation if I Hide and Exclude the unneccesary data in the raw-d...
Fabian88

Discussions |
Jun 27, 2017 6:39 AM

13031 views | 9 replies
method comparison for censored data

Hi group, I would like to compare thow analytical methods that are interval-censored (limit of quantitation - upper limit of quantitation). So I have observations with values of <3 (LOQ) as well as >120 (Upper LOQ). Usually Bland-Altman would do but in this case I am not sure.Some people suggest for the lowest to substituting BQL observations with LOQ/2. But how about the upper LOQ?There was discu...
david_arteta

Discussions |
Jun 27, 2017 5:17 AM

13466 views | 11 replies

Previous
Next

Latest Discussions

Select a group of cells in a column

Hi, I have table with thousands of rows. I need to be able to select a group of cells in one column, so I could copy it into another table. for example for Column: "Test3 (VOLTS)" only I need to copy cells highlighted in yellow from row 4 thru row 18 using JSL code.Thanks
SamH

Discussions |
Jun 26, 2017 3:21 PM

16487 views | 11 replies
Adding Data Labels in a graph using scripting

Hello,I need help in adding the Data Labels in a graph using Scripting. I want to display always the data value of the recent row. I marked the column as Label, and I also marked the row as label. But I don't know how can I write the script for the same.
sibanibisoyi

Discussions |
Jun 26, 2017 4:10 AM

3905 views | 1 replies
Response Surface

Dear JMP Experts, In the attached picture I created a surface plot with the graph-surface plot function. I created a color scheme with discrete color option. I am wondering what is the cut-off points for each of the colors? In another word, does the bright red mean the highest results? Does the dark red mean the stable region? How can I find explanations? Is there a way to show the cut off points...
xiaoyaj0

Discussions |
Jun 26, 2017 1:59 AM

3682 views | 1 replies
Survival Analysis Question

HiI have some data and I want to calculate overall and disease specific survival. While the alive/dead are 1/0 for the survival analysis with censor=1, how should I code the list for disease specific mortaility. How should I code the ones that are dead, but not due to the disease in questions, 1 or 0? or should they be excluded?
sajanjiv

Discussions |
Jun 23, 2017 11:54 AM

4590 views | 2 replies
Assign values to factor level in a definitive screen design

Hello all, I have a seven continuous three-level factors for a DOE. Definitive Screen Desgin (DSD) seems better fit my purpose. For each factor, I have three phisical test samples to be assigned to the three levels. However, they don't represent the max and min values of the factor. How do I assign the physical values to each factor level in the design? Thanks,John
ZenCar

Discussions |
Jun 23, 2017 4:32 AM

9186 views | 7 replies

Previous
Next

Latest Discussions

JSL How do I wrap the title text of a OutlineBox?

Hi all, I often use the Set Title() message to overwrite the OutlineBox titles of charts, distributions, etc. My first issue is that the OutlineBox does not support the Set Wrap() message. Is there any replacement I could use? To work around the missing Set Wrap(), I started inserting newlines "\!n" in the tiitle text. After doing this, I have noticed a second issue: Whatever number of newlines I ...
AlexanderKrebs

Discussions |
Jun 13, 2017 5:38 AM

4567 views | 0 replies
Printing worksheet with cell colors

Hello JMP Community, I'm currently using JMP version 10.0.0 and having trouble printing my data table with cells highlighted in certain colors. Is there a way to print keeping the colors or to even export the file keeping the cells highlighted?

Thanks.
ferdt58

Discussions |
May 16, 2017 9:14 AM

2281 views | 0 replies
Linearity and Bias Report

In Our MSA stsudy we are performing Linearity and Bias measurment. We are currently controlling at Linearity and Bias to be below 5%. We actually generate the following report for Linearity and BIas. However in AIAG handbook the criteria for the gauge to pass bias criteria has the following criteria.
Aravindan

Discussions |
Apr 18, 2017 12:54 AM

4529 views | 0 replies
CCC Optimal

Hi,I have 2 clustering chooses as mentionned below,- Nr of cluster 15 : CCC = 69.99 (OPTIMAL)- Nr of cluster 15 : CCC = -92.87- Nr of cluster 15 : CCC = -112.8 The first one with CCC = 69.99 is mentionned as the best optimal. I don't understand why this one is the best by consedering the different values ?. What is the signification of these values ? Thanks,
Lamine

Discussions |
Mar 17, 2017 5:25 AM

3426 views | 0 replies
Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?

My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger

Discussions |
Feb 26, 2017 9:30 AM

3539 views | 0 replies