JMP User Community

Latest Discussions

How to retrieve tabulated values by script

Dear Community, Based on the Tabulated output below, please how can I retrieve the amounts for categories 1, 2, 3 by script? Based on another working script I`m currently there in my tries: r = TabulateQuantiles << report; tb_TabQuant = r[Table Box( 1 )]; tb_TabQuant << GetText; QuantAmount1 = tb_TabQuant[2][1]; QuantAmount2 = tb_TabQuant[2][2]; QuantAmount3 = tb_TabQuant[2][2]; Show(QuantA...
HubP_SDe

Discussions |
Dec 23, 2020 3:14 AM

2875 views | 6 replies
How to convert timestamp data to duration time for each batch using jsl script

Hi all, I have started using JSL and is currently on a beginner level. My data consists of time-series batch data for different process variables. Each batch has a different time series range/ processing time. Data resolution is 1 hr. First, I want to convert the batch start time (Real-time) into duration time starting at time point zero (0) and then accumulate to the end Real-time. I think...
MK1985

Discussions |
Dec 23, 2020 1:28 AM

2773 views | 3 replies
Unlock column created with a formula and modify its content

Hello JMP team,i have a set of data that I obtained from a temp sensor. Column 8 below has the time in the following format: hh:mm:ss:ms, the ms has three digits. I tired converting the column format to a time (only available option is h:m:s) but it is not working for some reason.I have also used the Munger in the formula and deleted the ms portion in column 8, obtained data is in the 1st column (...
AFaiz

Discussions |
Dec 22, 2020 5:08 PM

2336 views | 4 replies
Radio Button Multiple Columns

I would like a single radio box with two vertical columns of four buttons each. The user could select one of the eight buttons only. Is there a way to do this? I tried to make to radio boxes (one for each vertical column) and then Group them together, but it does not seem to work. Thanks
Martin

Discussions |
Dec 22, 2020 3:13 PM

2000 views | 1 replies
How do I round up or round down dates?

Hello,If I have a bunch of Opentimes in the format MMDDYYYY hh:mm and I would like to fix any of these dates that occur between the hours of 1am and 3:59am to "round up" to 4am.In other words if my Opentime is 10/09/2020 3:12 AM, I need that to round up to 10/09/2020 4:00 AM. Conversely I have Closetimes in same format and I would like to fix any of these dates that occur between the hours of 1am ...
fionaweston

Discussions |
Dec 22, 2020 1:45 PM

3368 views | 3 replies

Previous
Next

Latest Discussions

Unlock column created with a formula and modify its content

Hello JMP team,i have a set of data that I obtained from a temp sensor. Column 8 below has the time in the following format: hh:mm:ss:ms, the ms has three digits. I tired converting the column format to a time (only available option is h:m:s) but it is not working for some reason.I have also used the Munger in the formula and deleted the ms portion in column 8, obtained data is in the 1st column (...
AFaiz

Discussions |
Dec 22, 2020 5:08 PM

2336 views | 4 replies
When there is no interaction, can I use multiple comparison such as LSD or Tukey test?

I have three factors - Genotype (5 levels), Nitrogen (2 levels), and manipulation (2 levels). I'm interested in the combination of three factors. I'd like to check how average grain weight responds to defoliation under the different nitrogen conditions. When I analyze it as the full factorial, there was no interaction among genotype x nitrogen x manipulation. However, I want to indicate the diffe...
JK

Discussions |
Dec 22, 2020 9:25 AM

1798 views | 1 replies
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

1594 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

991 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

7905 views | 8 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

1324 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

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

1268 views | 0 replies