JMP User Community

Latest Discussions

How to create a formula column that extract letters/numbers from an ID?

I have a list of ID numbers. However, I only number which is important to me is the last five digits from the ID number. I'm sure there's a formula column script we could utilize to perform this. For example:The id number that i have is 24KL-L200123. I just need to create a formula column that could pull the last 5 digits and the end result would be 00123. Thanks. sincerely appreciate any advise o...
Danial1

Discussions |
Dec 21, 2020 5:33 AM

5372 views | 5 replies
JSL > Maximizing Symbol Size Range in Graph Builder

Hi JMP Community,I have used extensively the Size variable to vary the size of Markers in Graph Builder but I have not been able to increase the range of sizes beyond the predefined option in GB. Indeed, if I increase the overall size of Markers, the entire range shifts without increasing the contrast between the smallest and largest markers (see below: Left = Marker Size Large; Right = Marker Siz...
Thierry_S

Discussions |
Dec 20, 2020 11:29 AM

1810 views | 3 replies
How do we filter data based on time and take the average using JSL?

I have data captured for a particular duration of time. Please find below snapshot of the table (attached the same):TimeStampABC0.00110.005450.4451428.90930.00210.01450.8904429.02950.00310.015451.336429.01770.00410.02451.7818428.92790.00510.025452.2278428.8491 The plot of column C looks like below:
I need to filter the rows in section1 , 2 & 3 and find their average.Each section spans for 30second ...
jojmp

Discussions |
Dec 20, 2020 4:45 AM

3305 views | 4 replies
How to import multiple pdf files into data table

Warning: I am new to scripting Challenge:I have about 500 pdf files, each containing a data table I want to import to JMP and collate into a single jmp data table. Work flow & issues:I made a script (see below) that allows me to import the tabulated data from one pdf and append it to a table I called Final.jmp. I kept the script as a separate file, i.e. not inside a data table. Each pdf is appende...
Ressel

Discussions |
Dec 19, 2020 12:58 PM

2570 views | 4 replies
How to make the Y axis on the left side

Please remind me (briefly) how to make the Y axis on the left side (in Distribution platform or in Preferences. Not in Builder). Look at the picture, pls. Thanks in advance!
Ted

Discussions |
Dec 19, 2020 7:51 AM

1691 views | 1 replies

Previous
Next

Latest Discussions

Why does the Default DoE Custom Design have so little sampling of middle levels?

When doing a Custom Design, sometimes middle levels (other than the highest and lowest) are specified, so it is more than 2 levels. However, Custom Design Default design tends to suppress sampling of these middle levels, putting most weight on the highest and lowest of each parameter. How is this determined? Can we specify to add more in the middle?
FredChen

Discussions |
Dec 19, 2020 7:46 AM

1605 views | 2 replies
Add a configuration setting when connecting a database (postgresql) with JMP in the same CustomSQL() instruction

Hi,I would like to speed up some SQL queries with special configuration values for my postgresql database.For example: SET random_page_cost = 1 How can I do this in JMP?Indeed if I create a CustomSQL querySET random_page_cost = 1Then a another one with a classic SELECT FROM... it doesn't work because the value "random_page_cost" seems to be reset to its default value on the second database connect...
Franck_R

Discussions |
Dec 18, 2020 11:24 AM

993 views | 1 replies
Can I use a dichotomous dependent variable in a mixed model (e.g., logistic mixed model)?

If I choose the mixed model personality then select a dichotomous dependent variable it jumps out of the mixed model personality. I can run "nominal Logistic" regression, but that no longer gives me the estimates for the random effects.
jeff_kiesner

Discussions |
Dec 18, 2020 10:44 AM

7907 views | 8 replies
test data STDF to dispay units

i have an stdf file from test data im able to extract a limits table from the file. but i do not have units. any idea how to get the test limits units from the stdf files ??
steo45

Discussions |
Dec 17, 2020 4:21 AM

2405 views | 4 replies
Generalized Regression vs Standard Least Squares

I have a 32 row data set of 6 factors and 1 response from a DOE I just performed. The response data is not normally distributed and should only contain values between 0 and 1. I saw the generalized regression platform in JMP Pro allows you to specify a variety of distributions including the beta distribution where the response is between 0 and 1. However, I also found a function I can use to trans...
avogadrosmole

Discussions |
Dec 11, 2020 7:26 AM

2458 views | 4 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

1523 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

1326 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

831 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

1039 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

1271 views | 0 replies