JMP User Community

Latest Discussions

Write in columns calculated values

Hello, I have a project and my purpose is to extract from my data table (1) the average, maximum and minimum value for each column, and write the results into a new table (2). I found this part of the code and it seems to work for few columns, but not for all. I have like 300 columns and I have the results for only twenty of them. For( i = 1, i <= N Col( dt ), i++, If (:Trial[i] =="TrialName",...
Nuroffen

Discussions |
Apr 15, 2022 8:16 AM

1578 views | 4 replies
Need help with populating Col List Box

Part of my App's GUI has a button that opens a table, and a Col List Box that I need to populate with columns from that table.If I open the table first and then create Col Lis Box as in this modified Example from Scripting Index, everything works fine:Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); New Window( "Col List Box Example", lb = Col List Box() ); lb << Append (dt...
miguello

Discussions |
Apr 15, 2022 7:37 AM

2126 views | 3 replies
import csv and only change format of few columns

I have some csv files that need to be imported and there are a few fields that correlate to software versions. However they are in the csv like x.y.z and are not encapsulated in quotes so JMP tries to bring it in as a numeric data type. When it does so, JMP believes the number is a date and converts it to a date so it's very difficult to convert back to a usable version. If I manually import a fil...
nathan-clark

Discussions |
Apr 15, 2022 5:20 AM

3047 views | 5 replies
How to pull discreet numbers from "smoother" fit from scatter chart

Hello, I am plotting a series of different devices and their signal response responses as a function of time. I wish to pull from each smoother plot the time value once the plot crosses a value, say 3100. The scatter data is too coarse to get the time at which this occurs however if there is a function behind the smoother fit for each device then this information should be available. Does anyone ...
ZeoliteChemist

Discussions |
Apr 15, 2022 4:57 AM

1135 views | 2 replies
How to creat a graph with significant difference marks(asterisk) in it.

I have a data set with active/placebo sides been tested for 4 times at 0w, 4w, 8w and 12w. i want to run a t-test to see that whether each side(active and placebo) become significantly different at 4w, 8w and 12w comparing with 0w. Actually I already knew the answer by using Excel, but I want to build a graph with significant difference marks(asterisks) in it using JMP. How could I build such grap...
AlphaPony501

Discussions |
Apr 14, 2022 9:36 PM

5388 views | 1 replies

Previous
Next

Latest Discussions

Write in columns calculated values

Hello, I have a project and my purpose is to extract from my data table (1) the average, maximum and minimum value for each column, and write the results into a new table (2). I found this part of the code and it seems to work for few columns, but not for all. I have like 300 columns and I have the results for only twenty of them. For( i = 1, i <= N Col( dt ), i++, If (:Trial[i] =="TrialName",...
Nuroffen

Discussions |
Apr 15, 2022 8:16 AM

1578 views | 4 replies
Need help with populating Col List Box

Part of my App's GUI has a button that opens a table, and a Col List Box that I need to populate with columns from that table.If I open the table first and then create Col Lis Box as in this modified Example from Scripting Index, everything works fine:Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); New Window( "Col List Box Example", lb = Col List Box() ); lb << Append (dt...
miguello

Discussions |
Apr 15, 2022 7:37 AM

2126 views | 3 replies
How to pull discreet numbers from "smoother" fit from scatter chart

Hello, I am plotting a series of different devices and their signal response responses as a function of time. I wish to pull from each smoother plot the time value once the plot crosses a value, say 3100. The scatter data is too coarse to get the time at which this occurs however if there is a function behind the smoother fit for each device then this information should be available. Does anyone ...
ZeoliteChemist

Discussions |
Apr 15, 2022 4:57 AM

1135 views | 2 replies
How to creat a graph with significant difference marks(asterisk) in it.

I have a data set with active/placebo sides been tested for 4 times at 0w, 4w, 8w and 12w. i want to run a t-test to see that whether each side(active and placebo) become significantly different at 4w, 8w and 12w comparing with 0w. Actually I already knew the answer by using Excel, but I want to build a graph with significant difference marks(asterisks) in it using JMP. How could I build such grap...
AlphaPony501

Discussions |
Apr 14, 2022 9:36 PM

5388 views | 1 replies
Apply JSL script to multiple sheets from excel

So I have an excel file with multiple sheets that have the same kind of dataframe (just different values) in each of the sheets. I was able to export a script for "Fit Y by X"Open(); Fit Group( Bivariate( Y( :Total_Cost ), X( :LGP1 ), Automatic Recalc( 1 ) ), Bivariate( Y( :Total_Cost ), X( :iteration ), Automatic Recalc( 1 ) ), Bivariate( Y( :LGP2 ), X( :LGP1 ), Automatic Recalc( 1 ) ), Biva...
pgkla

Discussions |
Apr 14, 2022 12:52 PM

986 views | 1 replies

Previous
Next

Latest Discussions

Error When Trying to Create User to Access the JMP Virtual Lab

While taking the Exploratory Data Analysis module, it is time to practice. However, when trying to access the JMP Virtual Lab, I cannot get past the "Create User" option. JMP VIRTUAL LABTo use the Virtual Lab, please select the Create User link below. If you would prefer to use software on your own machine, please select the Download Data link below.
Create User Download Course Data Clicking the C...
TielsForTheWin

Discussions |
Apr 14, 2022 10:48 AM

790 views | 0 replies
Column Switcher Button Removed from Plot Window Toolbar in JMP 16 for Mac

Recently switched from JMP15 for Mac to JMP16 for Mac. I was surprised to see the column switcher button removed as an option in an analysis/plot window. It used to reside up top next to the local data filter button (see black circle). The option to customize it back is also missing and has been replaced by a 'properties' button. This may also prove useful but I'm new to it. To get the colum...
datanaut

Discussions |
Mar 17, 2022 3:18 PM

841 views | 0 replies
No table linking after saving the project?

Hi,when I generate a summary table with the option "link to original data table" (selected by default), the two tables are linked:By selecting a row in the summary table the corresponding rows in the original table are selected.Cool.This also works for selections in Graphs and Dashboards.Very cool! Now my problem:After saving both tables to a project file, (precisely: after close & re-open the pro...
hogi

Discussions |
Feb 3, 2022 4:19 AM

593 views | 0 replies
Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

764 views | 0 replies
How to introduce lower bounds for simulated data in Profiler platform

Hi JMP community, (JMP Pro 16.0.0) I'm hoping to find out if there is a way to include lower bounds to simulated data in the Profiler platform. I have several predictors going into a model, but few data points to fit. So, in order to generate simulated ("synthetic") data, I use the Prediction Profiler platform along with the multivariate correlation structure of the data to generate thousands ...
SDF1

Discussions |
Feb 1, 2022 11:09 AM

585 views | 0 replies