JMP User Community

Latest Discussions

Fill in column values based on a sequence creation relying on table values

I have a process data table including Start timestamp and End timestamp. I would like that the duration of the process is calculated from the timestamps, and then additional rows are added .Column values of start timestamp are added by increasing the time by 1 minute till the End time is reached. All the other values in the table should be just copied to the next row.
IloinenHamsteri

Discussions |
Sep 13, 2024 6:36 AM

1359 views | 3 replies
How to set a Reference Line on each page with Page option in Graph Builder?

The following script plots some charts with the page option in graph builder? How to I set a horizontal reference line, for each chart, say at Weight = 80Kg and label it (80kg) using JSL?(I need the reference line to remain even if there is a change in the number of charts plotted)Names Default To Here(1); dt = open("$SAMPLE_DATA/Big Class.jmp"); gb = dt << Graph Builder( Size(528, 2954), Show...
Neo

Discussions |
Sep 13, 2024 3:30 AM

4112 views | 10 replies
passing a variable into a Cusum script

Hi Folks, When I run the below script, the target value as per variable Targ of 8 is not being passed to the CuSum chart. Instead a Target value of 8.09629 is calculated and used. What's going on, and how do a pass a target value of 8 into the script ? Thanks Names Default To Here( 1 ); targ = 8; dt = Open( "$SAMPLE_DATA/Quality Control/Oil1 Cusum.jmp" ); obj = dt << CUSUM Control Chart( Y(...
BrianK

Discussions |
Sep 13, 2024 1:16 AM

2562 views | 6 replies
I was able to invoke csv files and concatenate them to a JMP table. I added some editing (modify column names, add column names, etc). I want to invoke another user defined csv file as another jmp table and extract information from that to add to the first concatenated JMP table

Please see my script so far. At the end of the script, I want to open another csv file into a jmp table and extract columns into the originally created jmp table from the first invocation. Names Default To Here(1); //dt = Open( "C:\Users\VISHAL.SANGHAI\OneDrive - MiniCircuits\Documents\Mini Circuits Work Folder\US-AMP\US-AMP-2\Pkg data V1 old epi June 2024 testing\Power with new epi boards - Jul...
vishalsanghai88

Discussions |
Sep 12, 2024 11:38 PM

935 views | 1 replies
2 bugs with Tables/Summary

Hi,I just detected 2 nasty bugs in Tables/Summary.
One of them can even be used to make JMP crash on any PC (!!!) Bug 1) Please read this code and predict what Jmp will do: Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Summary( Local Data Filter( Add Filter( columns( :sex ), Where( :sex == "X" ) ) ), Group( :sex ), Mean( :height ), Link to original data table(0), o...
hogi

Discussions |
Sep 12, 2024 1:26 PM

2908 views | 6 replies

Previous
Next

Latest Discussions

I was able to invoke csv files and concatenate them to a JMP table. I added some editing (modify column names, add column names, etc). I want to invoke another user defined csv file as another jmp table and extract information from that to add to the first concatenated JMP table

Please see my script so far. At the end of the script, I want to open another csv file into a jmp table and extract columns into the originally created jmp table from the first invocation. Names Default To Here(1); //dt = Open( "C:\Users\VISHAL.SANGHAI\OneDrive - MiniCircuits\Documents\Mini Circuits Work Folder\US-AMP\US-AMP-2\Pkg data V1 old epi June 2024 testing\Power with new epi boards - Jul...
vishalsanghai88

Discussions |
Sep 12, 2024 11:38 PM

935 views | 1 replies
2 bugs with Tables/Summary

Hi,I just detected 2 nasty bugs in Tables/Summary.
One of them can even be used to make JMP crash on any PC (!!!) Bug 1) Please read this code and predict what Jmp will do: Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Summary( Local Data Filter( Add Filter( columns( :sex ), Where( :sex == "X" ) ) ), Group( :sex ), Mean( :height ), Link to original data table(0), o...
hogi

Discussions |
Sep 12, 2024 1:26 PM

2908 views | 6 replies
Using R script in JMP

Dear Community, I have read a past post on this topic regarding using R Init(), R Send()....etc to send data from JMP table and utilize the R to peform the task. However it does not show more in details on how to do it. For example I have a R script attached and would like to use this R Script to run in JMP. How should it be modify or scripted in JSL using those RInit()....etc? Thanks to advise. B...
Zappy

Discussions |
Sep 12, 2024 7:23 AM

1177 views | 1 replies
Enable button box after pressing enter at a Number edit box

I have the following window:What I am trying to do is to enable the 'Select data to import' button after pressing enter at the Number Edit window above.docId = "xxxxxx"; WidthDescripWin = 500; init_value =31; win = New Window("Landing page for study evaluation add-in", <<On close(EndAddin()), << Padding( {Left( 10 ), Top( 10 ), Right( 10 ), Bottom( 10 )} ), // Construction of landing page....
Georgios_Tsim

Discussions |
Sep 11, 2024 10:57 AM

1364 views | 3 replies
Access script of each journal outline box

Is there a way to access each individual report inside a journal as a script. i am writing a script where i want to access each report inside a jounral and modify some of their properties using jsl script? so is there a way to access individual script of reports in journal and modify them in jsl to reflect on the journal ? kindly guide
ComplexNerd

Discussions |
Sep 11, 2024 8:37 AM

898 views | 1 replies

Previous
Next

Latest Discussions

App Interface saved in a journal

Hi There
Some time ago, I created a nice interface using Application Builder and I saved it as a journal. Now I need to make a few modifications to the interface, rearrange buttons, add boxes, and so on. I am unable to import the journal into the app and have the interface appear in the Module tab. It is a very busy interface ...Is there a way to have it?
Thanks
Mioffe

Discussions |
Aug 7, 2024 5:01 PM

656 views | 0 replies
Tracking down a cycle error

When I open a data table, I get a cycle detected error that I have to ignore every time. I can't seem to figure out what is causing the error although it apparently has something to do with the table variable in my column formula. Here is the formula: and here is the log entry showing the issue Can anyone help me understand what is going on here? The data table actually works fine after I click ...
scott1588

Discussions |
Jun 24, 2024 11:47 AM

1098 views | 0 replies
How do I make scattorplot Matrix with multiple cloumns I select?

Hi. I'm Jeon.I'm beginner of JMP. I want to have a script for making scattorplot Matrix with Items I select.Could you give me a help with it? I splited one data table to two data table. one has value of test items(*Data type : Numeric & Continuous) , another one has upper limit & lower limit.(*Charactor & Norminal) Column names(=test item names) are the same in 2 different data table. Two sample d...
NagneTE1

Discussions |
May 27, 2024 5:18 PM

784 views | 0 replies
graph builder bug - x group shift

(JMP 17, MacOS) I have a JSL scripts that creates multiple graph builder charts, but in some of them, and it's not repeatable always - some of the x groups are getting different height, causing also the data plotted to be shifted. Another issue - is that I can't set the X group lables text to be 90 degrees rotated to fit long strings without making the chart too wide. This is supported for X var...
ShlomiB76

Discussions |
Apr 14, 2024 12:08 AM

719 views | 0 replies
Project ignoring H Splitter Box Set Sizes . . . sometimes

I'm working with a JMP 17 Project and have a script to import a CSV file, embed a script into the Data Table, and execute the embedded script. The embedded script creates a graph from the data and sets the Project layout. All of these pieces, executed individually, work as intended. The problem I am having is that when I execute the combined script, the outer H Splitter Box ignores <<Set Sizes and...
ionatx

Discussions |
Apr 4, 2024 1:25 PM

709 views | 0 replies