JMP User Community

Latest Discussions

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

4389 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
Adding custom text and values to plots on different pages using a for loop

Hi, I've attached a data table which aims to add a custom caption to each page of an X/Y plot graph builder report generated from the script saved within.Page is being controlled by the :Group variable, I need a way to add custom text along with a custom summary statistic (%CV in this case) to the plot for each :Group.For the most part the script is working (i.e. the text and the statistic are dis...
EDM

Discussions |
Jun 28, 2023 8:13 AM

1555 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

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

1051 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