JMP User Community

Latest Discussions

Conditional formatting by row state of different columns.

Good Day, I have 1.7mil rows of data that are linked with common identifiers. I can format smaller portions of it it in Excel but with the size of the file (greater than the excel limit) and the need to reproduce similar data sets I would like to figure out how to code the data in JMP. --- Column A (FID) is a series of fish identification numbers (1,2,3…) with a variable number of reads which pop...
Frogger

Discussions |
Jun 28, 2023 1:41 PM

2885 views | 3 replies
Equivalent of get rows where for multiple arrays

Hello, This seems like a quite basic question, but I'm likely using the wrong search terms because I haven't found a good answer. I have a script where initially I was just making a list of strings (file paths) and could use them in sequential order without issue. As the scope expanded, I now need to do filtering based on criteria in two other lists of the same length that were created at the sam...
CitizenNo3

Discussions |
Jun 28, 2023 1:21 PM

2010 views | 3 replies
Join data into existing table

I'd like to join two data tables by a matching column. However, I do not want JMP to create a new table with the result. The joined columns from the second table should be appended at the first table. I thought the "Update main table ..." option would do this, however it does not work for me (tested JMP 14 and 15). How can I make this work? Here's a minimal example demonstrating the issue: I have ...
JWi

Discussions |
Jun 28, 2023 1:14 PM

4150 views | 4 replies
Using Update() to add new rows into main table

I am trying to update a table that sometimes contains new rows (based on an index). It seems that I need to use join, as the following does not seem to work (here, the index is name column). Names Default To Here( 1 ); dt1 = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt2 = New Table( "Little Class", Add Rows( 3 ), New Column( "name", Character, Nominal, Set Values( {"ALICE", "NEW_NAME", "OTHER_...
FN

Discussions |
Jun 28, 2023 1:08 PM

4391 views | 8 replies
How can I apply stacked data in Hierarchical Clustering?

Hi, I have a dataset in which one of the columns has some numeric values based on measurement at different known temperatures. The temperature at which the measurement is done is in another column. How can I cluster my experiments including these numeric values? My numeric values are not directly comparable since higher temperatures in nature yield higher measured values. Is it an example of stack...
RepeatedPony834

Discussions |
Jun 28, 2023 8:45 AM

1489 views | 2 replies

Previous
Next

Latest Discussions

How can I apply stacked data in Hierarchical Clustering?

Hi, I have a dataset in which one of the columns has some numeric values based on measurement at different known temperatures. The temperature at which the measurement is done is in another column. How can I cluster my experiments including these numeric values? My numeric values are not directly comparable since higher temperatures in nature yield higher measured values. Is it an example of stack...
RepeatedPony834

Discussions |
Jun 28, 2023 8:45 AM

1489 views | 2 replies
Hover Labels: send a more precise filter?

I want to generate a hover graphlet from another data table following a recipe provided by @nascif_jmp. The problem that I am facing can be reproduced with a single data table.The below example looks extremely boring - "why does he want to plot a single point ?!?"... but makes sense when two different data tables are used [main data table with median values, hover plot with individual values] : )...
hogi

Discussions |
Jun 28, 2023 7:24 AM

2874 views | 6 replies
Calculating confidence bands in QQ plots

I have been trying to create a QQ plot using Excel which mimics the QQ plots performed by SAS JMP for normally distributed data. I am however not able to precisely mimics the confidence bands performed by SAS JMP. I have been calculating the normal quantiles using the formulas provided in the following link:Statistical Details for the Normal Quantile Plot (jmp.com) The standardised residuals are ...
BenjaminALK

Discussions |
Jun 28, 2023 6:41 AM

2647 views | 1 replies
How to rotate a label?

In the Scripting Guide I found the commandText Box<<Rotate Text(direction)
Is there a command to rotate the labels in Graph Builder? Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); Data Table( "Big Class" ):height << Format( "Percent", 5, 0 ); gb = Graph Builder( Variables( X( :sex ), X( :age, Position( 1 ) ), Y( :height ), Overlay( :sex ) ), Elements( Bar( X( 1 ), X( 2 ), Y...
hogi

Discussions |
Jun 28, 2023 4:48 AM

1573 views | 2 replies
Adding reported numbers to Boxplots

Is there any way to add the median and st dev to a boxplot?
ndowidar

Discussions |
Jun 27, 2023 2:21 PM

863 views | 1 replies

Previous
Next

Latest Discussions

Design space profiler not showing number of random sample

Hi, I just started to use the new design space profiler in <JMP 17.0.0>. I am wondering why in some cases I can add a number of random sample and sometimes not when starting the design space profiler. I used the design space profiler with several responses fitted with their prediction formula. This is the window that is sometimes not showing up Has anyone experienced the same problem? Emmanuel
eruffet

Discussions |
Jun 27, 2023 12:53 AM

676 views | 0 replies
bounded KDE (Kernel Density Estimator)?

Has anyone created or heard of function for JSL that returns a bounded KDE (Kernel Density Estimator)? I'm aware of the KDE used inside of the distribution platform, but one is not able to provide bounds to the domain.
Prokaryote

Discussions |
Jun 23, 2023 11:56 AM

772 views | 0 replies
How to set Scale Values in Graph Builder use Col Quantile function?

HI, I want set Scale Values in Graph Builder use Col Quantile function, but always something wrong. the red code have some problem. I need color scale as Quantile Graph Builder( Size( 839, 726 ), Variables( X( :Prober_X ), Y( :Prober_Y ), Color( :OpticalPower ) ), Elements( Points( X, Y, Legend( 6 ) ) ), SendToReport( Dispatch( {}, "400", ScaleBox, {Legend Model( 6, Pr...
Solarwing

Discussions |
Jun 20, 2023 9:32 AM

657 views | 0 replies
New Series on JSL and Visual Code Studio

Just a heads up that we've been posting some additional JSL tricks on our LinkedIn Blog. We have a weekly series that's been running currently focused on our Visual Code Studio Extension for JMP. Week 1: https://www.linkedin.com/posts/predictum_automationjmp-series-use-vs-code-extension-activity-7062456347543359488-uzFu?utm_source=share&utm_medium=member_desktopWeek 2: https://www.linkedin.com/...
wjlevin

Discussions |
Jun 19, 2023 2:26 PM

1052 views | 0 replies
Overlaying histograms: Iterating a function through N number of columns?

@PatrickGiuliano , As a response to our latest discussion : Re: How to overlay histograms in JMP Thanks a lot for the response. Also, 1) I would like to get more guidance on ' possibilities of iterating the Overlap function for more columns ( N number of Columns), if possible. the code for : Y Function(N, x): can be iterated ? Y Function(N, x);
For(i = 1, i <= N Col(xm), i++,
ym[i] = Min(Normal D...
DecileDromedary

Discussions |
Jun 19, 2023 6:31 AM

591 views | 0 replies