JMP User Community

Latest Discussions

How to properly use LAG function in Conditional Statements?

I have this formula but it is adding the value on the same row. If( :Column 2 != Lag( :Column 2 ) | Row() == 1, :Column 1, Row() == 2 | Lag( :Column 2, 1 ) != :Column 2, :Column 2 - (:Column 1 + Lag( :Column 1, 1 )), Lag( :Result ) - :Column 1 ) What I would want to do is something like this:Column 1 and Column 2 are given values. If Column 2 value changes, the result should be like the star...
UserID16644

Discussions |
Feb 22, 2024 5:36 AM

1774 views | 6 replies
How to subtract values from previous row values?

Hi all Can someone help me how to formulate a formula that would subtract Column 2 to the previous value in Column 1? It should look like this. The column Equation only shows how the subtraction of values should be.TIA
UserID16644

Discussions |
Feb 22, 2024 4:15 AM

2689 views | 7 replies
Date Difference calculation referencing grouping columns

I am trying to calculate a Date Difference in Days between the current row and the last row where a comment is non-missing. Any help greatly appreciated! If( (:ID == Lag( :ID ) | Row() == 1) & !Is Missing( :Comments ), 0, Date Difference( :Sampled Date, Lag(:Sampled Date, n=last row where !Is Missing(:Comments)), "Day" ) )
ktbrickey

Discussions |
Feb 22, 2024 2:56 AM

3109 views | 7 replies
How to pass parameters to the specified JSL in the graph fetch?

Examples in the index of softwaredt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); gb = dt << Graph Builder( Show Control Panel( 0 ), Variables( X( :age ), Y( :weight ) ), Elements( Bar( X, Y, Legend( 7 ) ) )); frame = (gb << report)[FrameBox( 1 )]; frame << Set Graphlet( Picture( loader = Include( "$BUILTIN_SCRIPTS/hllib.jsl" ); hlp = loader:lazyLoad( "hllPresets" ); hlp:launchPie(); ), Titl...
lala

Discussions |
Feb 22, 2024 12:55 AM

2565 views | 11 replies
group file name and set lable by JSL looping, work fine but slowly

I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...
BayesRabbit7133

Discussions |
Feb 22, 2024 12:24 AM

527 views | 0 replies

Previous
Next

Latest Discussions

How to pass parameters to the specified JSL in the graph fetch?

Examples in the index of softwaredt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); gb = dt << Graph Builder( Show Control Panel( 0 ), Variables( X( :age ), Y( :weight ) ), Elements( Bar( X, Y, Legend( 7 ) ) )); frame = (gb << report)[FrameBox( 1 )]; frame << Set Graphlet( Picture( loader = Include( "$BUILTIN_SCRIPTS/hllib.jsl" ); hlp = loader:lazyLoad( "hllPresets" ); hlp:launchPie(); ), Titl...
lala

Discussions |
Feb 22, 2024 12:55 AM

2565 views | 11 replies
group file name and set lable by JSL looping, work fine but slowly

I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...
BayesRabbit7133

Discussions |
Feb 22, 2024 12:24 AM

527 views | 0 replies
Working on multiple data files and creating a summary table that contains the mean, std, etc.

Hi, Lets say we have multiple big class data files, with different height, weight column, etc and I want to create a summary table that contains the mean, standard deviation, cpk, Spec limits, etc. I want to have a summary data table that lists the mean for example, for the first big class file, do the same thing for the next big class file. Is there are a method that I can use to perform such ...
RA899

Discussions |
Feb 21, 2024 10:07 AM

1051 views | 3 replies
Excel cell format

Hello

I'm encountering an issue with inconsistent cell formatting across multiple Excel files. I've written a script that imports all Excel files within a specific folder and then creates a new table with selected data from these files. However, I'm running into a problem because some of the Excel files have cells formatted as 'General', while others are formatted as 'Number'. This discrepancy in ...
SeasonalControl

Discussions |
Feb 21, 2024 7:34 AM

924 views | 2 replies
How to add JSL to "Big Class.jmp" graphics using Hover Labels?

Start with the following JSL to generate the graph.
How to add JSL through Hover Labels to get cell name data Get "Big Class Families" file corresponding name data?dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); p1 = dt << Graph Builder( Variables( X( :weight ), Y( :height ), Group X( :age ), Color( :sex ) ), Elements( Bar( X, Y, Legend( 5 ), Response Axis( "X" ) ) ) );
lala

Discussions |
Feb 21, 2024 7:09 AM

1546 views | 8 replies

Previous
Next

Latest Discussions

group file name and set lable by JSL looping, work fine but slowly

I have a JLS works fine, but slowly, is there any method to improve it? 1. import multiple files2. base on file name rule group into a, b, c, d, e 3. base on file name rule to decide file count and set into rows for each groupNames Default To Here(1); dir = Pick Directory( "Select a directory" ); Multiple File Import( <<Set Folder( dir ), <<Set Show Hidden( 0 ), <<Set Subfolders( 0 ), <<Se...
BayesRabbit7133

Discussions |
Feb 22, 2024 12:24 AM

527 views | 0 replies
JMP 16 Discreet Fit to Gamma Poisson to Kulmogrov

Hello All, Need assistance trying to get the goodness-of-fit test for the following parameters in JMP 16: 1. Discrete Fit2. Fit Negative Binomial (equivalent to Gamma Poisson as no option to choose gamma poisson)3. Goodness-of-fit4. output -> Pearson Chi-square -> no values From past version of JMP 14, there was a gamma poisson option with a goodness-of-fit option that outputted kolmogorov's D va...
RichC

Discussions |
Feb 19, 2024 10:19 AM

434 views | 0 replies
Visualizing 2-way clustering

Hello - I have a table of 180 factors. I have used the 2-way clustering to visualize the grouping in the dendrogram, which works really well for a few factors. Close to 200? Not so much, especially in a paper. In my mind, I have basically the K-means type plot of all of the factors clumped and colored. But this doesn't make sense for factors. Is there a way that to plot the clustering on a 2-D plo...
ehchandlerjr

Discussions |
Feb 15, 2024 2:53 PM

440 views | 0 replies
Help with JMP formula (IFERROR)

My excel formula is: =+IF(AND(E98=1, E108=1), IFERROR(E121-E$128, "NA"), "NA"). E98 = 1. E108 = 1. E121 is a calculation that came out to .267993337. E128 is a calculation that came out to -0.2792984. How can I re-create that formula in JMP? I'm trying with no success.
UpliftElk866

Discussions |
Feb 13, 2024 12:19 PM

471 views | 0 replies
Scheduled job failed

Hi, I'm trying to run daily scheduled job, but keep getting failing error "Process is terminated due to StackOverflowException".What might be the reason for this?
shaiv90

Discussions |
Feb 11, 2024 11:09 PM

527 views | 0 replies