JMP User Community

Latest Discussions

average based on different colums

Dear all,I have different products. And each product have different batches. And I have different containers of each batch. I analyze 3 location of each container. How can I calculate mean value of each container obtained from different batches and products. And how can I calculate the mean of each product. Please find enclosed my JMP document. I would be very grateful if you don't let me fish, ...
nac

Discussions |
Feb 16, 2022 10:14 PM

2240 views | 6 replies
JSL, delete a column if there's only 1 'group', labeled in another column?

Curious about this. I've got a dt with several thousand columns that I'm scripting some cleansing for further analysis. The data set is process data, where each row is a unique process run from a given machine. Some machines don't report out all the full list of sensors, so I'm stuck with a few hundred columns only coming from a single machine. I'd like to purge these, as I can't do any statistica...
aliegner1

Discussions |
Feb 16, 2022 4:48 PM

1217 views | 3 replies
Heatmap with Entire Row and Column Selections

I have a 2x3 heatmap that I am able to plot using Graph Builder - no problems. What I would like to do is have an additional set of cells for the user to select entire rows or entire columns of cells. It would look something like this:Question: How can I add the additional C1, C2, R1, R2, and R3 cells to the heat map to allow for the selection of the entire row or column of cells (data table row...
Martin

Discussions |
Feb 16, 2022 2:24 PM

3047 views | 7 replies
Adjusting spacing between figure categories

Is there a way to adjust the spacing between categories within figures. I frequently make bar graphs and dot plots with multiple categories and am unable to distinguish different groups. In this example I am plotting mass against SAID (Sample IDs) and number of cycles. I would like to separate the SAIDs to help visualize the samples separately. Is there a way to do this without changing the width ...
MW_JMP

Discussions |
Feb 16, 2022 11:21 AM

1799 views | 2 replies
Get value for grand median from a variability chart

JMP can plot a line for grand median on a variability chart, but how to show or extract its value?(I can get JMP to show the value for the grand mean but not for grand median)
Neo

Discussions |
Feb 16, 2022 5:08 AM

1256 views | 1 replies

Previous
Next

Latest Discussions

JSL, delete a column if there's only 1 'group', labeled in another column?

Curious about this. I've got a dt with several thousand columns that I'm scripting some cleansing for further analysis. The data set is process data, where each row is a unique process run from a given machine. Some machines don't report out all the full list of sensors, so I'm stuck with a few hundred columns only coming from a single machine. I'd like to purge these, as I can't do any statistica...
aliegner1

Discussions |
Feb 16, 2022 4:48 PM

1217 views | 3 replies
Heatmap with Entire Row and Column Selections

I have a 2x3 heatmap that I am able to plot using Graph Builder - no problems. What I would like to do is have an additional set of cells for the user to select entire rows or entire columns of cells. It would look something like this:Question: How can I add the additional C1, C2, R1, R2, and R3 cells to the heat map to allow for the selection of the entire row or column of cells (data table row...
Martin

Discussions |
Feb 16, 2022 2:24 PM

3047 views | 7 replies
Adjusting spacing between figure categories

Is there a way to adjust the spacing between categories within figures. I frequently make bar graphs and dot plots with multiple categories and am unable to distinguish different groups. In this example I am plotting mass against SAID (Sample IDs) and number of cycles. I would like to separate the SAIDs to help visualize the samples separately. Is there a way to do this without changing the width ...
MW_JMP

Discussions |
Feb 16, 2022 11:21 AM

1799 views | 2 replies
这个网站的数据怎样用脚本分析地址怎样获取并下载？

大家好!这个网站是异步加载数据的怎样用脚本分析地址怎样获取并下载？谢谢！
lala

Discussions |
Feb 15, 2022 10:53 PM

1262 views | 2 replies
Force Excel Import Wizard to Use Character for All Columns?

I am trying to import several one sheet from several auto-generated Excel tables and then concatenate into a larger file. The problem is that the first row contains the 'blank' data which has no batch/lot/etc. info, and the Excel cells have 'general' as the format. The next three columns are empty for the 'blank' but full for all other rows (samples). The first (batch) always imports correctly ...
andersonmj2

Discussions |
Feb 15, 2022 7:30 AM

3589 views | 4 replies

Previous
Next

Latest Discussions

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

770 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
M1 Macbook Pro JMP Capabilities

Hi all,
I'm thinking about upgrading from my windows set-up and running a M1 Macbook Pro as my primary set up. I wanted to open up the discussion and see if any other JMP users were using the newest Macbook Pro and if they have run into any hurdles yet? I do a lot of R/Python integration. I do have a decent set up right now, but want to know if anyone else has tested out this connection and knows ...
MikeDereviankin

Discussions |
Jan 21, 2022 1:52 PM

789 views | 0 replies