JMP User Community

Latest Discussions

Closing SQL query after running

Hello, I have a JSL script that calls for different SQL queries. After the data table is complete, I want to close the queries. Is this possible? query = Close( "C:\\example.jmpquery" ) does not work. Thanks.
Polyabc

Discussions |
Dec 30, 2020 11:55 PM

5274 views | 10 replies
JSL to summarize delta ranges in different column

Hello, I have a data table that had 6 repeat test data set. I need to summarize index from each test but not sure how to do so: For each test, I need to summarize the time range (column 1) in between -0.5 to 0.5. For example for test 1, time between -0.5 to 0.5 is 12.Is this something doable in summary table or formula? What would be the right script for this? Any help is highly appreciated. Thank...
yuedeng1015

Discussions |
Dec 30, 2020 9:55 AM

1596 views | 2 replies
How to prevent Run in Fit Model from producing a report?

I am writing a script that does the following: Opens a Fit Model window,Allows the user to populate it using the Macros and other functionality in the Fit Model window,Allows the user to click Run, at which point a possibly time-intensive calculation is performed and a report is produced. The calculation that is performed when Run is clicked is produced by a script stored in the Run button. This ...
marie_gaudard

Discussions |
Dec 30, 2020 8:35 AM

4778 views | 10 replies
Summarize function Date

I pretty new to jmp and have been trying to gain as much knowledge as possible on the the scripting language. I have been referencing both the scripting guide and the index if I run into any issues. As far as the Summarize function is concerned, is there somethin I am missing.... I am attempting to pull the min and max date and I am getting a rather large numerical value.As far as the formattin...
dhurw

Discussions |
Dec 29, 2020 2:23 PM

3492 views | 9 replies
Using variables in path name

Hello, Please forgive me if this is a trivial question, I do not have much experience working with JSL. I am trying to add a picture to the hover label using JSL code, and want to define the picture path using a variable. I have a folder of pictures, and want them to be called using a variable in my table. For example, my pictures are labeled 1 to 100, and I have a column in my table called "...
Polyabc

Discussions |
Dec 29, 2020 9:29 AM

6171 views | 10 replies

Previous
Next

Latest Discussions

JSL to summarize delta ranges in different column

Hello, I have a data table that had 6 repeat test data set. I need to summarize index from each test but not sure how to do so: For each test, I need to summarize the time range (column 1) in between -0.5 to 0.5. For example for test 1, time between -0.5 to 0.5 is 12.Is this something doable in summary table or formula? What would be the right script for this? Any help is highly appreciated. Thank...
yuedeng1015

Discussions |
Dec 30, 2020 9:55 AM

1596 views | 2 replies
How do I ensure that my scalebox does not stay fixed in size

I kindly need help in to create a JSL script that does not make my variability chart scalebox stay fixed in one size because I'm having problems to see any values when the value is outside my control limits. Below is an image how the chart looks like for a given script. Appreciate it if someone could advise me how to let it ensure all the points inside this chart Variability Chart( Y( :chart_valu...
Danial1

Discussions |
Dec 29, 2020 7:59 AM

1868 views | 3 replies
TRUE/FALSE data from Excel importing as 1/0

After recently upgrading to JMP15, all of my TRUE/FALSE data columns are importing from Excel as Numerical 1/0 instead of text. I have searched and can't find a preference or setting for this. How do I make sure the columns import as TRUE/FALSE? This didn't happen in JMP14.
geneticjunkie

Discussions |
Dec 26, 2020 11:59 PM

1973 views | 1 replies
How to check categorical to categorical correlations in data

Hi,

I have data like this and I would like to correlation between fail column to other categorical columns.

What is stat test in jmp and how can we apply that?
Any suggestions?
joshua

Discussions |
Dec 25, 2020 12:14 PM

4252 views | 4 replies
Definitive Screen Design (DSD) Model confirmation

Hi all, I designed a DSD with the following info:- Design: 7 continuous and 1 categorical factors, 22 run- Design Evaluation on power and correlation: very good- Fit model via Fit Definitive Screening: excellentRMSE = 0.2803, RSq =0.997, PValue<0.001)Lack of Fit: no (F Ration 191, Prob > F = 0.0561)Residual and Studentized Residuals are all good- Model structure: Contains 5 main, 4 quadratic and 1...
ZenCar

Discussions |
Dec 24, 2020 12:54 PM

5077 views | 12 replies

Previous
Next

Latest Discussions

Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1515 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1323 views | 0 replies
How to run a Post hoc for Chi Square results in JMP?

I was wondering if someone can help me. I want to run a post hoc analysis for the chi square results in JMP. Thanks
vmendez17

Discussions |
Oct 22, 2020 7:33 PM

828 views | 0 replies
Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

1037 views | 0 replies
Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1268 views | 0 replies