JMP User Community

Latest Discussions

delete CHAR cols if there's only a single value, no string variation

Wondering how I can script something to look at all the columns to see if there's at least 2 different values and delete all the single-value cols? I have thousands of 'feature' cols, all character-type, but a noticeable amount of them only have a single record in them...aka the distribution level = 1. how to detect and delete 1-record cols?
TriangularLlama

Discussions |
Oct 26, 2024 10:14 AM

1276 views | 3 replies
Optimizing Desirability With Uncontrolled Factor

I am looking for advice on how to automate maximizing the desirability of a process profile when I am locking one of the factors and having the others optimize around it. My process has an uncontrolled factor, so I need to adapt to what it's doing per unit I measure. My desired response can generally be achieved by adjusting the controlled factors, but the desirability situation is unique per valu...
V1N0V3R1T4S

Discussions |
Oct 25, 2024 2:44 PM

1765 views | 5 replies
How to use different labels for the same bar chart?

Positive and negative values like this use different cotton swabsThanks!dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); r = N Row( dt );ca = "weight";ar = dt << GetAsMatrix( ca ); For( i = 1, i <= r, i++, ar[i, 1] = -ar[i, 1]);dt[0, ca] = ar; c1 = Quantile( 0.8, dt[0, "height"] );c2 = Quantile( 0.2, dt[0, "weight"] ); ca = "A";New Column( ca );Column( ca ) << Formula( If( height > c1, height ) );dt <<...
lala

Discussions |
Oct 25, 2024 1:24 AM

1479 views | 5 replies
Unable to run addins within Project

We have organized many scripts into an addin for our company. The addin responds but scripts will not run when invoked within 'Project'. Is this something that can be remedied through the addin scripting or does the script itself have to be contained separately within the project?
LynnWarren

Discussions |
Oct 24, 2024 10:20 PM

3518 views | 8 replies
How to calculate moving averages for selected rows

Hello everyone! I am trying to write a script that will calculate moving averages using selected rows in a table. To set the stage: I have a data table (example attached) with multiple executions (Unique ID) of a 3 stage process (A, B, C). There is a reported value for each stage and these values are summed to give a Total value for each occasion. I would like to have a column that reports a mo...
ClusterFerret68

Discussions |
Oct 24, 2024 8:21 AM

2661 views | 6 replies

Previous
Next

Latest Discussions

delete CHAR cols if there's only a single value, no string variation

Wondering how I can script something to look at all the columns to see if there's at least 2 different values and delete all the single-value cols? I have thousands of 'feature' cols, all character-type, but a noticeable amount of them only have a single record in them...aka the distribution level = 1. how to detect and delete 1-record cols?
TriangularLlama

Discussions |
Oct 26, 2024 10:14 AM

1276 views | 3 replies
Optimizing Desirability With Uncontrolled Factor

I am looking for advice on how to automate maximizing the desirability of a process profile when I am locking one of the factors and having the others optimize around it. My process has an uncontrolled factor, so I need to adapt to what it's doing per unit I measure. My desired response can generally be achieved by adjusting the controlled factors, but the desirability situation is unique per valu...
V1N0V3R1T4S

Discussions |
Oct 25, 2024 2:44 PM

1765 views | 5 replies
Unable to run addins within Project

We have organized many scripts into an addin for our company. The addin responds but scripts will not run when invoked within 'Project'. Is this something that can be remedied through the addin scripting or does the script itself have to be contained separately within the project?
LynnWarren

Discussions |
Oct 24, 2024 10:20 PM

3518 views | 8 replies
JMP Slow Down after On Close with selection window

Hello, I'm trying to prompt users to make a selection of groups from a window that opens at the start of a script that defines an object to be used for the remainder of the script. When the user selects and uses the button box, it works great, but if they close with the window, JMP slows down and it becomes impossible to edit the script window without right clicking>Stop Script. Does anyone have ...
RahBarroso

Discussions |
Oct 23, 2024 7:57 AM

1227 views | 4 replies
Summary Statistics of all numeric columns by grouping variable

I borrowed a section of another JSL that someone wrote a while back, but unfortunately has left the company now.Original JSL creates box plots along with a table with summary statistics of all numeric columns by grouping variable ("split").My goal is to get only the summary table with Summary Statistics (Mean, Std-dev) of all numeric columns by grouping variable.I am using JMP16. Sample input data...
vikramavtar

Discussions |
Oct 23, 2024 7:10 AM

1809 views | 5 replies

Previous
Next

Latest Discussions

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

709 views | 0 replies
Could JMP show in a single graph a sensitivity analysis and the probability of occurrence of a result?

Hello Community!Attached is the script "Hogi chart calculates risk and probability", an excellent work by HOGI ... which calculates the risks and probabilities of occurrence of an input or multiple inputs (x), of an output or multiple outputs (Y) or their combination in a table. For example:Would it be possible to expand the capacity of the script to make a sensitivity analysis of the inputs (x) o...
Marco2024

Discussions |
Oct 2, 2024 5:15 PM

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