JMP User Community

Latest Discussions

How do I use the Col Maximum Formula with a "where" condition

Hi, I have a problem where I want to formulate a new column as a benchmark to all other countries. If there are more rows for the country, I want to take the max value of it as the benchmark. See the example below for clarification. Data kind of looks like this:
Country Value period A 10 201301 A 30 201301 ...
apploarcher

Discussions |
Nov 11, 2024 2:03 PM

21644 views | 19 replies
Script command to check whether a selection criteria returns >0 selected rows

I'm looking for a scripting command that checks whether a selection contains >0 selected rows. The issue: subsetting a table of selected rows when none are selected, stops the script and returns an error message. I circumvent this problem by creating a column that sets selected rows to 1, then take col sum and run the if command (if col sum > 0, subset, don't subset). But that's clunky and for loo...
Monomorphist

Discussions |
Nov 11, 2024 1:23 PM

1195 views | 4 replies
Open JMP took longer time in JMP18.1 compared to JMP17.2

Hello expert, We have 5 PCs with JMP license - JMP 17.2. We just upgraded 1 license to JMP 18.1 for software & system testing. Observed that JMP 18.1 took longer time to open compared to JMP 17.2. The difference is almost 20 secs. (It's really troublesome because I need to open JMP during meeting with our management & they cannot wait additional 20 secs) Anyone else having this issue? Why does...
WebDesignesCrow

Discussions |
Nov 11, 2024 10:12 AM

3038 views | 9 replies
How do I pass in a variable number of variables to a function as an array?

I am hoping to make some functions I have a little more reusable as an example, I am creating a summary table with specific columns from my data set. I would like to pass in the columns list as an argument to allow me to have one "GetSummary" function rather than a "GetExperimentsSummary" and "GetCompoundsSummary" , but as these need different numbers of columns I need to be able to package the li...
chappe

Discussions |
Nov 11, 2024 9:46 AM

582 views | 1 replies
Capability summary - change shade levels

Hello! Was wondering if anyone could help me with the following.Is there a way to change the "shade colouring" that JMP uses in the Capability Summary table? I would like to have these rules:- ppl and/or ppu below value of 1: red- ppl and/or ppu between 1 and 1.67: yellow- ppl and/or ppu above value of 1.67: green Currently JMP uses different rules (not sure which one exactly): I've tried to pl...
Jonas_Aji

Discussions |
Nov 11, 2024 6:40 AM

2554 views | 4 replies

Previous
Next

Latest Discussions

How do I pass in a variable number of variables to a function as an array?

I am hoping to make some functions I have a little more reusable as an example, I am creating a summary table with specific columns from my data set. I would like to pass in the columns list as an argument to allow me to have one "GetSummary" function rather than a "GetExperimentsSummary" and "GetCompoundsSummary" , but as these need different numbers of columns I need to be able to package the li...
chappe

Discussions |
Nov 11, 2024 9:46 AM

582 views | 1 replies
Wait(0) vs Wait(n) vs Run vs Finish

I have very large, and constantly growing data tables so I have issues with formulas not finishing. I wish JMP would just build in a mechanism to stop scripts from continuing until each line has finished but perhaps there is a reason for not doing this I'm not thinking of. I typically use a wait(n) command (e.g. wait(30);) however as the dataset grows I'm constantly having to update countless inst...
RVhydrA

Discussions |
Nov 11, 2024 3:59 AM

4000 views | 5 replies
How to get CV% for an unbalanced Precision study

Hello JMP community, I have some data for Precision study with an unbalanced design. As shown below, there are ten runs performed with reagent lot 2 and 3 on two instruments (A and B). The fully automated instrument has three docks (locations) for the 96-well plate. The same sample was tested with 3 replicates in each of the ten runs by one operator. The goal is to calculate CV% for intra-run, int...
Jinweidu80

Discussions |
Nov 11, 2024 1:36 AM

1213 views | 3 replies
wilks lambada

Hi I am trying without luck to run this test. I have a species (string) plus two data columns. I am getting no results. Can anyone advise?
gw21

Discussions |
Nov 10, 2024 11:15 AM

476 views | 1 replies
Why is Tables/Concatenate so slow?

Has this ever happened to you?
Sometimes it takes a very long time for Tables/Concatenate to finish merging two tables.More than a minute for just a few columns and some 100k rows.What could be the reason?
hogi

Discussions |
Nov 9, 2024 8:33 AM

1135 views | 4 replies

Previous
Next

Latest Discussions

column and table selection

The new Messages in Workflow Builder are great.
Is there a possibility to pick a column from he current data table - or an open table?

hogi

Discussions |
Nov 7, 2024 10:31 AM

380 views | 0 replies
Data Visualization in Virtual Reality

Has anyone considered or have any interest in visualizing JMP plots (e.g., 3D scatter, surface) in virtual reality? I know there are several immersive VR programs (Arthur, Virtualitics, NVIDIA Omniverse) that can handle data and images generated from other program and I was wondering if anyone has made any attempts to do the same with JMP. Would love to hear back from anyone interested.
PieBird215

Discussions |
Nov 7, 2024 9:58 AM

593 views | 0 replies
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

539 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

584 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

507 views | 0 replies