JMP User Community

Latest Discussions

How do I use an if statement and a by variable correctly in a column mean formula?

I'm trying to use the columne mean formula to show the Time 0 average value for a columen of test samples, grouped by the test sample types. I found this topic from 2012, that looked like it would work:https://community.jmp.com/t5/Discussions/Determine-column-mean-by-day-and-within-certain-hours/m-p/5477/highlight/true The recommended syntax there is:Col Mean( If( 1 <= :Hour <= 10, :x, Empty() ),...
rperkins

Discussions |
Jun 12, 2017 8:51 AM

7806 views | 2 replies
check if excel worksheet exsists

I would like to write JMP script which try to open specific worksheet from excel.The problem is if one of my excel files not including the requested worksheet, then the JMP script crush .I need advice how can I prevent it? (I mean, check before open the excel, if it including the requested worksheet..) this si my code:add_to_DB = function({file_path, sheet, header_line, data_line},

new_dt = Open(
fi...
Amir_y

Discussions |
Jun 12, 2017 5:37 AM

8234 views | 3 replies
I/O Problem

Suddenly i started getting I/O Problem. though it still reads the file by opening and closing. but its very annoying to get the pop-up when i am opening excel sheets using jsl. I/O problem.
Unable to open in ReadWrite mode.
The system cannot find the file specified.
ram

Discussions |
Jun 11, 2017 7:33 AM

10311 views | 1 replies
How to use a color scheme in "Graphic script"?

HI All,is there a way to use default color scheme for "add graphic script" when adding multiple lines and text?e.g in below code i want to use default color scheme for lines and text instead of hard coded.Motivation: I have to match the color of data to the lines and text, where my data is colored by a group.Line Style( 0 );
Pen Color( 6 );
Pen Size( 2 );
Text Size( 10 );
Try( X Function( 315.4, y, Ma...
ram

Discussions |
Jun 10, 2017 7:27 PM

5737 views | 5 replies
JSL List to matrix ?

Prob: needed to get a list or matrix of numbers instead of characters; String="1,2,3,4,5,6";list=words(String,","); //output --> {"1","2","3","4","5","6"} required output ={1,2,3,4,5,6};
ram

Discussions |
Jun 10, 2017 12:07 PM

9320 views | 4 replies

Previous
Next

Latest Discussions

How to use a color scheme in "Graphic script"?

HI All,is there a way to use default color scheme for "add graphic script" when adding multiple lines and text?e.g in below code i want to use default color scheme for lines and text instead of hard coded.Motivation: I have to match the color of data to the lines and text, where my data is colored by a group.Line Style( 0 );
Pen Color( 6 );
Pen Size( 2 );
Text Size( 10 );
Try( X Function( 315.4, y, Ma...
ram

Discussions |
Jun 10, 2017 7:27 PM

5737 views | 5 replies
how to analyse automaticly？

dear all： i have to monito abnomal ratio every day， but now everyday i open the JMP and then put excel data in JMP to analyse， that is trouble。 if i open jmp and then analyse automaticly how i write JSL to realize？
TONYMA

Discussions |
Jun 7, 2017 8:40 AM

4791 views | 3 replies
Function for back button

Hi, everyoneI can create a button named as "Back". But may I know is there any function that can back to the previous interface when i click the back button?
Thanks.
jade

Discussions |
Jun 2, 2017 4:50 AM

3647 views | 2 replies
Parallel Processing in Scripting

In the process of putting togother a lengthy script that makes some calls to ODBC/SQL databases that can each take several minutes to run. In an ideal world I could be waiting for multiple servers to get back to me at the same time. From what I am gathering I have to stick with just running one database request after another?I am running JMP 9.
firemandan9

Discussions |
May 31, 2017 12:46 PM

6998 views | 4 replies
Disabling all or individual check boxes not able to be re-enabled with opposite method

I have two sets of check boxes and one is being used to control which options are enabled on the other. I seem to have run into an issue using Enable and Enable Item. If I have previously disabled all the checkboxes I am unable to enable them individually unless I enable them all first. Conversly, if I disable individual check boxes, it appears I am unable to enable them all at once. As it is curr...
SG

Discussions |
May 30, 2017 12:14 PM

3754 views | 1 replies

Previous
Next

Latest Discussions

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

2282 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

4531 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
Data Binding Associative Arrays

I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp

Discussions |
Feb 14, 2017 1:53 PM

4534 views | 0 replies