JMP User Community

Latest Discussions

What type of analysis for an infrequently occurring event

Hi, I have a set of data that has recorded the frequency of spillages from lorry loads. I have recorded for the period of two years: load, date, time, number of bottles on the load, driver, weather, dusk/dawn etc. I want to identify risk factors for when spillages are most likely to occur. However, these spillages happen so infrequently that most of my data is 0. For example, I have 29,000 rows ...
AbbieGraham333

Discussions |
Jun 23, 2025 1:18 PM

701 views | 2 replies
WINDOWS > JMP 17.2 > Unstructured Text > How to Classify Based on Predefine Keywords

Hi JMP Community, I need to classify unstructured text annotations (see attached table) based on a list of predefined keywords. For example: GROUP1 AIZARANI_LIVER_C2_KUPFFER_CELLS_1 ==> MACROPHAGECUI_DEVELOPING_HEART_C8_MACROPHAGE ==> MACROPHAGE... GROUP2 AIZARANI_LIVER_C8_RESIDENT_B_CELLS_1 ==> B - PLASMA CELLSAIZARANI_LIVER_C22_RESIDENT_B_CELLS_2 ==> B - PLASMA CELLSHAY_BONE_MARROW_PLASMA_CE...
Thierry_S

Discussions |
Jun 23, 2025 10:51 AM

1217 views | 4 replies
Update Table Match Speed - which is faster: Matching multiple columns X, Y, Z (all integers) or Matching Col "X.Y.Z" unique combined string?

I'm Updating a large data table (4.4 million rows) of stacked data with design info from a much smaller table. I have 1,927 unique rows in the smaller table that correspond to the stacked parameter. They can be identified either by a column with a unique string (X.Y.Z), or the combination of three columns that contain X, Y and Z individually. The same columns (X, Y, Z and X.Y.Z) are in the larg...
MeanChris

Discussions |
Jun 23, 2025 9:32 AM

1079 views | 4 replies
Ajay Hinduja Geneva Switzerland : How do I integrate JMP with my website?

Hey Team, I’m Ajay Hinduja from Geneva, Switzerland, looking into integrating JMP with my website, and I need some advice on the best approach. I’m thinking about how to display or analyze data directly on the site, but I’m not sure where to start. If you’ve worked with JMP in a web context or have advice on similar integrations, I’d love to hear your thoughts or see examples. Regards Ajay Hi...
ajayhinduja25

Discussions |
Jun 23, 2025 3:15 AM

719 views | 2 replies
Issue with 'Save Script for All Objects': Missing Button Icons

I need to record the settings of the graph and the graph itself for future operations, so I tried using 'Save Script for All Objects'. As shown in the following JSL, after clicking on Plot, I pressed 'Save Report' to save it. However, in the output results, although the content of the graph is still there, the content related to the buttons does not appear, making it impossible for me to achieve t...
BabyDoragon

Discussions |
Jun 23, 2025 12:54 AM

393 views | 1 replies

Previous
Next

Latest Discussions

What type of analysis for an infrequently occurring event

Hi, I have a set of data that has recorded the frequency of spillages from lorry loads. I have recorded for the period of two years: load, date, time, number of bottles on the load, driver, weather, dusk/dawn etc. I want to identify risk factors for when spillages are most likely to occur. However, these spillages happen so infrequently that most of my data is 0. For example, I have 29,000 rows ...
AbbieGraham333

Discussions |
Jun 23, 2025 1:18 PM

701 views | 2 replies
Issue with 'Save Script for All Objects': Missing Button Icons

I need to record the settings of the graph and the graph itself for future operations, so I tried using 'Save Script for All Objects'. As shown in the following JSL, after clicking on Plot, I pressed 'Save Report' to save it. However, in the output results, although the content of the graph is still there, the content related to the buttons does not appear, making it impossible for me to achieve t...
BabyDoragon

Discussions |
Jun 23, 2025 12:54 AM

393 views | 1 replies
How to copy the list of column contributions of a random forest using a script?

Thanks Experts! dt = Open( "$SAMPLE_DATA/Diabetes.jmp" ); p= dt << Bootstrap Forest( Y( :Y ), X( :Age, :Gender, :BMI, :BP, :Total Cholesterol, :LDL, :HDL, :TCH, :LTG, :Glucose ), Validation( :Validation ), Minimum Splits Per Tree( 5 ), Portion Bootstrap( 1 ), Number Terms( 3 ), Number Trees( 25 ), Go ); p_report = p << Report; tb = p_report << XPath("//OutlineBox[text()='列贡献']//TableB...
lala

Discussions |
Jun 21, 2025 4:31 AM

994 views | 5 replies
How to dynamically assign X or Y variables in Graph Builder using JSL based on conditions?

Hi JMP Community, I'm trying to build a dynamic Graph Builder report in JSL where the list of X variables is determined by certain conditions (e.g., flags like includeSite, includeWW, etc.). The goal is to flexibly add or remove columns from the X-axis based on runtime logic. I’ve tried several approaches, including using: X( :ColumnName )
X( Column("ColumnName") )
Expr( X(...) )
Substitute(...) ...
RA899

Discussions |
Jun 20, 2025 9:36 AM

907 views | 4 replies
How do a split a column at the 5th character?

I have a column that I want to split. e.g 18.45> or 16.45< I want to make 1 column with the no. & 1 column with the < & >.
lisaash

Discussions |
Jun 20, 2025 5:05 AM

621 views | 2 replies

Previous
Next

Latest Discussions

Remove Crosshair in Profiler

Hello everyone, I am looking for a solution to remove the crosshair in the Prediction Profiler. Any kind of hack would be helpful, like e.g. changing the transparancy.
AnjaW

Discussions |
Jun 18, 2025 5:15 AM

435 views | 0 replies
How to export a model formula to Excel?

I want to be able to take the prediction formula that I got from my multiple linear regression and put it in excel. I have multiple Quantitative and Categorical X variables and some are splined. I have also preformed a BoxCox transformation. What are the steps that I need to do to take the formula that is given and have it working in excel. I have no coding experience but am not against learning a...
DWS

Discussions |
Jun 13, 2025 8:33 AM

483 views | 0 replies
Testing slices in JMP Pro Mixed Model?

Hello, I am doing a 4-way, full factorial ANOVA with one repeated measures factor (time, 3 samplings) and three between-subject factors (species, color, and irrigation; 2 levels of each) using the Mixed Model personality in JMP Pro 18.1.0. I'm using the AR(1) repeated covariance structure, as it provides the best fit based on AICc values. The analysis indicates I have no significant 4- or 3-way in...
JHS

Discussions |
May 7, 2025 7:38 AM

667 views | 0 replies
Help with Multiple Linear Regression
LogitParrot179

Discussions |
Apr 23, 2025 7:58 PM

586 views | 0 replies
when does model reduction lead to the problem of multiple comparisons?

My interest is in identifying the strongest predictors of annual per capita growth rate for three groups of bird species: residents, short-distance migrants and long-distance migrants. My model has per capita growth rate as the dependent variable, and as predictors bird density during the breeding season, and 13 environmental predictors (various measures of climate, food abundance and nest predat...
olddabbler

Discussions |
Apr 21, 2025 5:56 AM

570 views | 0 replies