JMP User Community

Latest Discussions

issue in for loop

hello All, I am not able to figure out why this for loop formula is not working. It simply creating a new column if units are in time and then covert it into Hours. Sample data is also attached. Thanks. ColNames = dt << get column names( string, Numeric, character, continuous, Nominal ); N Items( ColNames ); For( i = 1, i <= N Items( ColNames ), i++, If( Ends With( ColNames[i], "(secs)" ), New Col...
HSS

Discussions |
Mar 27, 2022 7:28 PM

1754 views | 4 replies
jsl code to change the "view" for a graph builder plot with X grouping?

Hi,the "group X" option generates 2 plots, one for "F" and one for "M".The option "First View Level" can be used to specify which "view" to start with , here: "M" (2nd view).is there a JSL code to prgrammatically change the "view", something like gr << Set X View Level (1) dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); gr = dt << Graph Builder( Variables( X( :height ), Y( :weight ), Group X( :sex,...
hogi

Discussions |
Mar 27, 2022 1:54 AM

1266 views | 2 replies
How do I sort data individually in a column when the data is given as a group?

The data I am looking at is movies and one of the columns is genres. However JMP has the genres that a particular movie is categorized under grouped as one data set "Fantasy|Horror|Romance|Thriller" rather than as individual movie genres "Fantasy", "Horror", "Romance", "Thriller". I want to separate the genre column so that I can analyze the genres individually. How would I clean the data so that ...
OrdinaryMink774

Discussions |
Mar 26, 2022 9:51 PM

1121 views | 1 replies
Missing function column in Calculator Window

I'm currently (real time) teaching a class and have encountered a JMP problem I've never seen before. One student's calculator window appears to be missing all of the functions on the left side of the screen. The columns appear and the calculator section of the window appears but there are no functions to choose from and I can't figure out how to get them back. I don't see anything in the prefe...
dale_lehman

Discussions |
Mar 26, 2022 2:18 PM

1641 views | 3 replies
Mixed Logit Model

How do I perform a Mixed Logit Model on JMP?
ARR

Discussions |
Mar 26, 2022 6:01 AM

857 views | 1 replies

Previous
Next

Latest Discussions

Mixed Logit Model

How do I perform a Mixed Logit Model on JMP?
ARR

Discussions |
Mar 26, 2022 6:01 AM

857 views | 1 replies
May I change Color of Col' head????

Hello,
I have a quick question.
Can I change the color of the JMP data table col' head?
As you can see now, we are dividing by changing the color of the cell, but it would be great if we could only change the head, not the whole.
(Actually, I think it would be better if we could form a group by column on data table toooo)
Thank you..
Dongjin

Discussions |
Mar 25, 2022 5:46 AM

906 views | 1 replies
Is it possible to have timestamp or part-id on X-axis in the Model driven Multivariate control chart?

JMP Model-driven multivariate control charts are great but unable to use in our factory as a daily driver due to MDMCC X-axis doesn't have date-time or part-ids.

Can someone help how to add time/ID to the x-axis?
anudeep39

Discussions |
Mar 25, 2022 4:09 AM

877 views | 1 replies
How to select & delete rows when the cell did not start with W

Hello,I have a table with 2 columns (Process & MC)I want to select and delete rows that fulfill 2 conditions below using scripting ;1. Column Process = WB2. Column MC = does not start with "W"I've checked through the scripting help but couldn't find anything useful. If I use below script, it will delete all rows that MC column cells starts with "W" which is not what I want. dt3 << select where(:P...
WebDesignesCrow

Discussions |
Mar 24, 2022 11:02 PM

762 views | 1 replies
Spec Limit

Hi,I would like to ask if I set a particular column with spec limit(eg. low:100 and max:1000), from this limit set how can I create a corresponding column say Pass/Fail column to label those data within limit as Pass and out of spec as Fail.Thank you.
OneSidedCharts1

Discussions |
Mar 24, 2022 11:00 PM

808 views | 1 replies

Previous
Next

Latest Discussions

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

842 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

599 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

771 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

589 views | 0 replies
Query Builder filtering on date stored in Varchar(20)

Query Builder - date filter.SQL ServerJMP version 16.2In the database (SQL Server) I get the Date field called RETURNDATE in ‘varchar20’ – I would like to use the Calendar functionality in the filter to select my dates I tried to create a calculated column (Calc1) and specify CAST([RETURNDATE] as date), which he doesn’t like. Using SQL outside Query BuilderSELECT TOP (1000) [LABJOBNO] ,[DESPA...
HansD

Discussions |
Jan 25, 2022 6:12 AM

1391 views | 0 replies