JMP User Community

Latest Discussions

How we can close an opened excel file using JSL?

How we can close an opened excel file using JSL?
ram

Discussions |
Jun 16, 2017 7:53 AM

9566 views | 8 replies
Sum specific values in certain rows/columns

Hi there,I'm working with an oddly layed out table of data. If you see the table below (not actual data, but a resemblence), I need to find the sum of all the red numbers, and then the sum of all of the green numbers. Preferably, an additional column woul be created and each row for Bob would read the red sum, and each row for Bill would read the green sum. Could anyone give me an overview of ho...
matt7109

Discussions |
Jun 16, 2017 5:17 AM

11975 views | 7 replies
How to fit a polynomial degree 2 models with by-groups then capture the parameter estimates

I would like to create polynomial degree 2 by each (SERIAL, P1, P2, P3) and get the coefficient and constant then put in each column by using JSL. The example data was attached in this post, but actually I will do with the data about 1 million rows.
Sibtid

Discussions |
Jun 15, 2017 6:58 PM

11729 views | 7 replies
Changing Legend Text

I am a new JMP user. I am trying to make an overlay plot of five datasets. I would like to change the legend title from the default 'Groups' and also the data-set labels inside the legend. When I double click the legend, I am able to type text in for both the title and the individual data sets. When I click OK, the legend title gets updated. But, the new series labelsthat I typed in manually does ...
AKHAR

Discussions |
Jun 15, 2017 5:36 PM

6507 views | 2 replies
Manipulating Summary Tables and Column Addition

Hi,I have two quesitons:1) How could I go about summing the values of a row between two columns. I found the snipet of code below, but it simply copies the 5th value and puts in in the new row. For each row, I want all values between the 5th row and the nth column of TR to be added. TotRow = dt << Get Column Names( Numeric ); TR = N Items( TotRow ); dt << New Column( "Total", Numeric ); For Each ...
matt7109

Discussions |
Jun 15, 2017 2:01 PM

3665 views | 1 replies

Previous
Next

Latest Discussions

How we can close an opened excel file using JSL?

How we can close an opened excel file using JSL?
ram

Discussions |
Jun 16, 2017 7:53 AM

9566 views | 8 replies
Manipulating Summary Tables and Column Addition

Hi,I have two quesitons:1) How could I go about summing the values of a row between two columns. I found the snipet of code below, but it simply copies the 5th value and puts in in the new row. For each row, I want all values between the 5th row and the nth column of TR to be added. TotRow = dt << Get Column Names( Numeric ); TR = N Items( TotRow ); dt << New Column( "Total", Numeric ); For Each ...
matt7109

Discussions |
Jun 15, 2017 2:01 PM

3665 views | 1 replies
Create Tabs without scrolling horizontally

Hi, all
May I know is there any function that can make if I have 25 tabs in one user interface, then for example every 5 tabs, it will automatic go down another row(meant here 1-5 in first row, then 6-10 in second row and etc), which can prevent the user to scroll horizontally to the right.I have search the scripting index for the tab list box, but I can't find any suitable the function.
Can anyone ...
blue1994

Discussions |
Jun 15, 2017 8:40 AM

8128 views | 3 replies
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

4568 views | 0 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

5736 views | 5 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

4568 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

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