JMP User Community

Latest Discussions

Is there anyway to make a column of negative numbers positive?

I'm having an issue where I want my data to be shown as absolute values. This is a query (in snowflake) with over 200 variable columns (depending on the filters) so it makes it difficult to include every column in the query. I'm ideally looking for a way to find all the columns with negative values and making them positive. (As I write this out, I guess I could transpose, place all the values in o...
OhThatArabGuy

Discussions |
Nov 1, 2024 10:20 PM

1395 views | 2 replies
Saving the file path of a user prompted Open() command

I'm prompting the user to open a file via this script command: Open() << Set Name( "results.jmp") How do I capture the file path of the file that the user chose to open?
bgolob

Discussions |
Nov 1, 2024 2:20 PM

925 views | 3 replies
comparing data in rows and naming according to column names

Greetings, I have a data set for which I would like to have a column formula that considers several rows, and then returns a name to the new column according to the row data, specifically the highest value among the selected rows. I would like the name returned to be the same name from those columns considered. Something like this, what would that formula be please? (Thank you ahead of time f...
jackpdavis

Discussions |
Nov 1, 2024 1:20 PM

1200 views | 4 replies
Gauge R&R interpretation when accounting for Crossed effects

The MSA used to calculate GaugeR&R recommends selecting Crossed as the Model type. This is a slightly different method compared to evaluating just the Main effects of Appraiser and Part which many spreadsheets and tools use to calculate Gauge. I understand the concept of crossed effects, but I'm having a difficult time understanding how the crossed variance calculation is made (i.e. if I want to h...
DSchweitzer

Discussions |
Nov 1, 2024 11:51 AM

1295 views | 3 replies
Linking data table with Scatterplot and question in RSM

Hi community, I have two questions two; one jmp specific implementation question and the other on DOE strategic question. I vaguely remember that there is a way to look at Scatterplot and data table more interactively. For instance, below I selected 4 rows that contain the variables on data table. I would like to have these conditions highlighted in the scatter plot on the right. Another question ...
BJK_JerseyBoy

Discussions |
Nov 1, 2024 11:13 AM

6674 views | 17 replies

Previous
Next

Latest Discussions

Is there anyway to make a column of negative numbers positive?

I'm having an issue where I want my data to be shown as absolute values. This is a query (in snowflake) with over 200 variable columns (depending on the filters) so it makes it difficult to include every column in the query. I'm ideally looking for a way to find all the columns with negative values and making them positive. (As I write this out, I guess I could transpose, place all the values in o...
OhThatArabGuy

Discussions |
Nov 1, 2024 10:20 PM

1395 views | 2 replies
Gauge R&R interpretation when accounting for Crossed effects

The MSA used to calculate GaugeR&R recommends selecting Crossed as the Model type. This is a slightly different method compared to evaluating just the Main effects of Appraiser and Part which many spreadsheets and tools use to calculate Gauge. I understand the concept of crossed effects, but I'm having a difficult time understanding how the crossed variance calculation is made (i.e. if I want to h...
DSchweitzer

Discussions |
Nov 1, 2024 11:51 AM

1295 views | 3 replies
DOE with dependent factores

I'm designing a DOE and decided to use the software. My DOE is made up of 6 factors defined as:layer thickness -> 0,03 and 0,06 mmLaser power -> from 100 to 400 WScanning speed -> from 400 to 1000 mm/sDistance scanning -> from 0,05 to 0,2 mmTemperature -> 0 and 200 ºCStrategy type -> chess and stripesHowever, factor 1, 2, 3 and 4 are by related by the following equation:Ev = 2/(1*3*4) and the vari...
StandardOkapi62

Discussions |
Nov 1, 2024 3:55 AM

1964 views | 7 replies
Dispatch()

I want to add reference lines to a graph, but only if the page has :name = "Closed Loop Control". The only way I have found to be successful is to grab it sequentially using the highlighted scalebox(5), however I want to grab it by the :name instead.
Jdho3

Discussions |
Oct 31, 2024 2:42 PM

507 views | 1 replies
Sequential numbering across different data tables

Hello all, I am pretty new to JSL, so I have this small doubt where I have 3 data tables, and each holds 12 rows. So, I want to add a line of code which gives me an output like for table1-the num col will be 1-12, for table2- the num col will be 13-24 and for table-3 the num col will be 25-36. Can you help me with this. Thank you in advance. <JSL> l = 117; w = 32; h = 43; ls = 19.6; ws = 16.4;...
MomentBeetle806

Discussions |
Oct 31, 2024 8:14 AM

614 views | 1 replies

Previous
Next

Latest Discussions

Error add-in manager :AddinID == selectionID

I am taking the above error once i click to build currently selected add-in button at the add-in manager. Error Message: {"Send Expects Scriptable Object"(1, {23}, 2, "Send", here:addinTable << /*###*/get rows where(:AddinID == selectionID) /*###*/)} Error: Send Expects Scriptable Object 1 time(s). Data Table Indices: 23 Type: Error Function Name: Send Function being executed: here:addinTab...
Georgios_Tsim

Discussions |
Oct 29, 2024 6:41 AM

535 views | 0 replies
JMP 18 Addins on Server - Change in Location

FYI from JMP tech support: If you are running JMP on a server, note that JMP 16 addins do not work for JMP 18 because the file paths have changed. JMP is no longer part of SAS so the file path changed from C:\ProgramData\SAS\JMP\addIns to C:\ProgramData\JMP\JMP\addIns

Changing your file path to C:\ProgramData\JMP\JMP\addIns will make addins visible for JMP version 18.
pmroz

Discussions |
Oct 29, 2024 5:58 AM

583 views | 0 replies
How do I replace a prediction expression in a fit model with a specific expression?

Hi, I am completing a DOE and I have ran a fit model using the JMP software to define a design space based on desirability of certain variables, however one of the desirability variables is a simple ratio of two of the construct model effects, however when running the model, the model is defining its own prediction expression for this variable rather than using the formula in the data table. Does ...
supermackie93

Discussions |
Oct 24, 2024 5:40 AM

501 views | 0 replies
One-Versus-Rest (OVR) and the One-Versus-One (OVO) LDA

Hello, I'm looking for a way to test a different LDA strategy than the standard One-off (or hand-out) method when trying to predict a categorical response with multiple classes. I'm particularly interested in the One-Versus-Rest (OVR) (also referred to as One-Versus-All or OVA) and the One-Versus-One (OVO) strategies. So, instead of using the default One-off LDA which seeks to solve the classica...
Quentin26

Discussions |
Oct 24, 2024 1:29 AM

703 views | 0 replies
Graph Builder: Ordering my overlay by descending order according to the total value of each overlay category

Hello community, I come to you with a difficult question. Please see the image below for reference. I am using JMP 18, and I am trying to create a bar chart to show PPB values by quarter for various categories. The trouble I run into is that I want the category that has the highest total value from the chart to be on the bottom of the stack. For example, in the image below the category memory shou...
AttributedMouse

Discussions |
Oct 22, 2024 1:37 PM

518 views | 0 replies