JMP User Community

Latest Discussions

How can I use a column formula to return the value of a specific row in another column?

Here is an example data table with the 4th column "Desired Formula Column" showing the outcome I am trying to get. GroupSample NumberData ValueDesired Formula ColumnA13535A2235A3135B12222B2422B3222C14040C2240C3340 I am looking for a column formula that will enter the data value for sample 1 for each group. Any help appreciated!
user8421

Discussions |
Dec 4, 2019 3:25 PM

3516 views | 2 replies
Is it possible to combine two pictures in one expression column?

Hi, I have a table with two expression columns containing pictures. When I hover the mouse over the data points only one picture is displayed, despite both columns being labelled. What is the easiest way to display both pictures at the same time? For instance, is it possible to combine the two pictures in a single expression column so that when this is labelled, both pictures get displayed?I have ...
nvi

Discussions |
Dec 4, 2019 1:11 PM

9181 views | 6 replies
Creating a Subset from an Interactive Graph?

Hello. I am trying to make an interactive graph to display data from a summary table. The goal is to create a line graph with points that can be clicked on to subset data from that particular point. For instance, in the script below, I have a graph of a summary table by age of the Big Class sample table. The user should be able to click on a point on the graph and have it automatically pull up a s...
dp

Discussions |
Dec 4, 2019 12:57 PM

9744 views | 4 replies
Script to Create Subset and Add Columns

New to scripting here, and trying to automate some of my work tasks. My goal is to create multiple subsets from a master file and add some columns that will allow me to factorize the data. Right now I am playing around with the data trying to learn. Here's what I have: //Select data table dt = Open( "FM_OwnshipState.jmp" ); //Card1 dt << Select Where( :LocalTime >= 6:59:00 & :LocalTime <= 6:59:...
mjvincent87

Discussions |
Dec 4, 2019 11:49 AM

3093 views | 2 replies
plotting multiple graphs from a large data table

Hi, I have a data table in which I track rise in measurement for different devices in different weeks and every day in current week.This table is dynamic and can have 30-40 products in some weeks.I need to plot rise trend and no of measurements in a graph.If I plot all devices the graph becomes clumsy.So I create a column device_number and would like to plot 5 devices in one graph.At the end I wan...
ENTHU

Discussions |
Dec 4, 2019 11:01 AM

5638 views | 2 replies

Previous
Next

Latest Discussions

Is it possible to combine two pictures in one expression column?

Hi, I have a table with two expression columns containing pictures. When I hover the mouse over the data points only one picture is displayed, despite both columns being labelled. What is the easiest way to display both pictures at the same time? For instance, is it possible to combine the two pictures in a single expression column so that when this is labelled, both pictures get displayed?I have ...
nvi

Discussions |
Dec 4, 2019 1:11 PM

9181 views | 6 replies
plotting multiple graphs from a large data table

Hi, I have a data table in which I track rise in measurement for different devices in different weeks and every day in current week.This table is dynamic and can have 30-40 products in some weeks.I need to plot rise trend and no of measurements in a graph.If I plot all devices the graph becomes clumsy.So I create a column device_number and would like to plot 5 devices in one graph.At the end I wan...
ENTHU

Discussions |
Dec 4, 2019 11:01 AM

5638 views | 2 replies
2 way analysis of covariance, repeated measures

I use JMP Pro 14.1.0 on a Mac. I want to perform repeated measures analysis of covariance. In my data there are two grouping variables for subjects, race/ethnic status (B v H v W) and gender (M v F), thus six cells of status & gender. There are six dependent variables, all derived from a parent-completed rating scale, so the dependent variables may be correlated. The subjects in each cell vary ...
OldGugga

Discussions |
Dec 3, 2019 9:23 AM

3682 views | 3 replies
saving global variable between JMP sessions

How I can define a variable that is recorded in JMP, so next time I open it I still have access to it? For example, global variables are defined as: ::my_global_variable = 42;
FN

Discussions |
Dec 3, 2019 7:14 AM

2835 views | 3 replies
Filter using FFT and IFFT (low pass, high pass or band pass)

I would like to filter out certain frequencies in a time series data set. With the spectral density in Time Series I can see the FFT and its peaks but I wonder if there is built-in filter to perform these type of DSP operations. For example, with FFT() one can do the inverse to have a new signal with only the selected frequencies.
FN

Discussions |
Nov 28, 2019 6:55 PM

4535 views | 2 replies

Previous
Next

Latest Discussions

Difference between std error in "Parameter Estimates" and "Least Squares Means Table"?

I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the standard error reported in the Least Squares Means table for the same effect. How are they calculated differently? Thanks!
Ranae

Discussions |
Nov 26, 2019 11:44 AM

1562 views | 0 replies
How can I run a .py python script and python scripts compiled as .exe from JMP

Hello, So I've written a JMP UI, and once I gather data from the user I have a button that dumps the form data to a CSV.Now I need to launch my python script and other .exe (as an administrator), my python scripts pick up the user input from the CSV and perform the next steps.Right now it's a .py but I may need to run it through py2exe and compile it into an exe later so a solution that supports...
xxvvcczz

Discussions |
Oct 30, 2019 6:44 PM

1929 views | 0 replies
Analysis of covariance (ANCOVA) for Split plot Design

Hi, I have a problem where I want to do ANCOVA and It is new for me.We have,Main plot data (2 treatments)Subplot data (10 treatments)Yield datawe want to add lodging (%) score as a covariate. How to do it? (I have seen some video tutorial from Youtube but its not easy to understand for me) Your cooperation will be highly appreciated.
Harun-Or-Rashid

Discussions |
Oct 29, 2019 9:03 PM

1298 views | 0 replies
Send Expects Scriptable Object in access or evaluation of 'Send' Error

I create a new window with variability chart, and put into journal. After that i want to save into pdf. But at the last line to save into PDF, it give me error like below. and nothing is saved into pdf. Need some advice which part i am doing wrong? ErrorSend Expects Scriptable Object in access or evaluation of 'Send' , report_R235 << /*###*/SavePDF( "C:\LimTY\NXP\Product\Pegasus\Characterization\...
OneNorthJMP

Discussions |
Oct 10, 2019 8:43 PM

1337 views | 0 replies
Extract Report Data and Export it to Excel

I am totally new to the JMP community and have a limited coding background. I am working with Life Distributions (Weibulls mostly), and I would like to create an Add-in that can do the following tasks once I have selected the best distribution fit: 1. Save specific report data from distribution (see the data tables in red) 2. Export the data into an excel sheet 3. Have the add-in button available ...
jemairsmartes

Discussions |
Sep 11, 2019 10:27 AM

2136 views | 0 replies