JMP User Community

Latest Discussions

How do I create another group of columns in JSL scripting

I want to group 30 columns of my data table into 2 group columns. My script as below; dt << group columns( "SeahawkDefects", :FBMissing Bond :: :SBBall Accuracy ); Current Data Table () << group columns( "TTDefects", :NU-No Unit :: :MP-Missing Phosphor ); I able to create the 1st group column (FBMissing Bond until SBBall Accuracy). But, when I use similar script to create the 2nd group (NU-...
WebDesignesCrow

Discussions |
Mar 15, 2022 11:52 PM

2247 views | 4 replies
User Input Tabulate Column

Is it possible to have a user-based column when tabulating data? I have a tabulated table but the grouping columns need to be based on the user input. I can't think of ways to do it, is it possible? pls help
UserID16644

Discussions |
Mar 15, 2022 11:29 PM

1540 views | 4 replies
how to fill columns missing content with a required content by JSL

kindly help to suggest how to fill columns missing content with a required content by JSL, from left to right, auto fill in missing content with "Sold", refer to below tables. (actually the table and the columns is not limited, more than the table list). many thanksFind on JSL but not work, :Name("Sold or not?")[ dt<< get selected rows ] = "Sold"; Column NameSold or not? Column NameSold or not?...
qspringleaf

Discussions |
Mar 15, 2022 9:07 PM

1872 views | 3 replies
Cannot set value from list a variable

Dear all, I try to do scripting, but find difficulty and need your help para ={"align_ratio_2","align_ratio_1","minchaseforcef_3","maxchaseholdforce_4"}; 1) U1L1_MEAN[1] = Col MEAN(TCB1L_U1:para[1]); 2) U1L1_MEAN[1] = Col MEAN(TCB1L_U1:align_ratio_2);
There are different outputs between 1 and 2. For further checking, the output from 2 is correct.
Can anyone help me how to correct statement 1

Since...
PhamBao

Discussions |
Mar 15, 2022 8:56 PM

820 views | 1 replies
Bivariate line style looping

Hi allI am trying to create a bivariate plot with group that needs different line styles. However, the group is varying depending on the given data. Here's a sample data, where it is grouped according to their occupation. How can I create a loop inside my function to create line style? biv = Bivariate( Y( :weight ), X( :height ), Group By( :occupation ), << Fit Li...
UserID16644

Discussions |
Mar 15, 2022 6:42 PM

2790 views | 8 replies

Previous
Next

Latest Discussions

Cannot set value from list a variable

Dear all, I try to do scripting, but find difficulty and need your help para ={"align_ratio_2","align_ratio_1","minchaseforcef_3","maxchaseholdforce_4"}; 1) U1L1_MEAN[1] = Col MEAN(TCB1L_U1:para[1]); 2) U1L1_MEAN[1] = Col MEAN(TCB1L_U1:align_ratio_2);
There are different outputs between 1 and 2. For further checking, the output from 2 is correct.
Can anyone help me how to correct statement 1

Since...
PhamBao

Discussions |
Mar 15, 2022 8:56 PM

820 views | 1 replies
Need some advice regarding parallelism test.

I am using JMP version 16.1 and working on comparing a nonlinear standard curve (ID- STD) against 3 other nonlinear curves (ID- Set A, B, C) to see if they are similar. What I did was plotting the 4 curves using analyze>specialized model>nonlinear set up as attached. After that I select logistic 4P and perform Parallelism test and Equivalence test. The p-value obtained is 0.0056 which is below 0.0...
Marcoz

Discussions |
Mar 15, 2022 4:42 PM

1630 views | 2 replies
How to change bar labels font in Graph Builder Stacked Bar Chart?

I made the following stacked bar chart in Graph Builder. As you can see, the labels in the bars are hard to read. How can I adjust that font? Bold, White would make them visible. I couldn't find an option in Graph > Customize.
markschahl

Discussions |
Mar 15, 2022 2:04 PM

1619 views | 1 replies
How to calculate row percentage for dimension subtotal?

I have the following data with 20+ measures. Raw data shown here is a sample with only one measure. With Tabulate I can get subtotal for each site for all levels of Var2 (0,1,2,3) and level of Var1 (A, B). For example, the subtotal for Site1=461 (438+19+2+2). I am comparing the percentage of measure for each level of Var2 between the level of Var1 for each Site. Table1 presents subtotal for each s...
helalmob

Discussions |
Mar 15, 2022 4:04 AM

1470 views | 2 replies
Graph Builder - Custom Marker Colors Not Saving in Script

Hi there - the graph that a colleague of mine made originally had markers color coded by a continuous column (see "Original" image). When they save the script and re-run the script to re-create the graph, the color-coding goes away and all of the markers become maroon (see "After" image). Do you have any suggestions for how to keep the color-coding such that each time the graph script is run, the ...
AU

Discussions |
Mar 14, 2022 5:08 PM

1209 views | 1 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