JMP User Community

Latest Discussions

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

8126 views | 3 replies
Data Filter only by columns that are of type 'character'

col_name_list_character=dt << Get Column Names("Character"); // would like (if possible) to only filter by columns of type character. // Same as filtering by col_name_list_character above // Button Box( " Activate Filter ", dfilter = dt << data filter( Mode( Show( 1 ), Include( 1 ) ), add filter() ) ), // // right now, the filter box has all columns (numeric and character)I am having a hard ti...
Jim_G_Pappas

Discussions |
Jun 14, 2017 2:22 AM

10381 views | 5 replies
Using specific row values for use in a formula with JSL

I would like to do something that I learnt a long time ago in VB, but am struggling with JMP scripting language. I am new to JMP.I would like to run a For loop in a formula but use a cell array. For example, I know I can reference a column as follows: j = Column ("a");If I then say j[4] = 77 + 2; I will get the value 79 in column “a”, row 4.What, though, if I wanted to run a loop on Column "a", ...
scottahindle

Discussions |
Jun 14, 2017 12:30 AM

16122 views | 5 replies
Saving Data Table to Excel format

Hi,Is there any way to save a data table into Excel (.xlsx) format with scripting?
kuanaunwei

Discussions |
Jun 13, 2017 11:59 PM

8257 views | 2 replies

Previous
Next

Latest Discussions

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

8126 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

4567 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
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

4790 views | 3 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

2280 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

4525 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