JMP User Community

Latest Discussions

New Create A column to count Cycle Time

Refer to below data table, how to New Create A column to count Cycle Time? kindly help to suggest. thanks a lot.1.need sort properly by "Group Name" and "Date".2. within same "Group Name", with "Date" increase, column"Count" number increases, after a certain level (the max value maybe not fixed, sometimes change), it will be back to small value, which means another cycle start. Group NameDateCount...
qspringleaf

Discussions |
Jul 18, 2020 4:44 AM

2866 views | 4 replies
Save Script to Data Table JSL Script Doesn't Work on Variability Gage R&R Charts

Hello together, applying a simple JSL Gage R&R script, I would like to save this variability charts into the table by using the JSL "Save Script to Data Table". Unfortenately, this doesn't work: This function works without problems on the graph builder, has someone an idea how it works succesfully on the variability charts?I'm using JMP 14.1.0. Thanks,Michel
Michel_AR

Discussions |
Jul 18, 2020 3:29 AM

2990 views | 3 replies
Setting Row Values Under a Given Condition

Hello, I am new to JSL and attempting to create a script that will change the value of certain rows in a given column. The general issue I am having is that my data is being categorized as from different locations, when in fact those sites are the same. So when I go to graph them, I get more groups than necessary. Here is the snippet of code that I was hoping would accomplish my goal: for each row...
lgober

Discussions |
Jul 17, 2020 1:33 PM

4938 views | 3 replies
two way anova with strongly unbalanced samples

In case like this, where the two sample sizes are so strongly different (25 vs 410), the standard anova test is it ok?
FR60

Discussions |
Jul 17, 2020 12:58 PM

6111 views | 6 replies
Converting a Julian Day into Month-Day

I receive material from a supplier that uses an encoded date in their material lot, which I'd like to convert to a regular date. It first encodes the three digit Julian date into a two-digit Base 36 hex, which I have found JMP can easily handle. But converting the Julian date to month-day has been surprisingly elusive. There isn't a mention of Julian conversion I can find. Seems like I should be ...
jay_holavarri

Discussions |
Jul 17, 2020 11:54 AM

6401 views | 1 replies

Previous
Next

Latest Discussions

Weighting Variables in regression models

I was wondering how to weight variables in a regression model. I have some variables that may contribute more to my model and I want to find a way to have JMP value these variables more so than other variables. I know I can enter them first into a stepwise regression model. I want to do that, but I also want to weight some variables more than others.
dross111E

Discussions |
Jul 17, 2020 7:36 AM

7689 views | 5 replies
How Do You display Regression Equation on Bivariate fit graph
Andrew_Botfield

Discussions |
Jul 17, 2020 2:41 AM

2453 views | 2 replies
Newbie Question extracting values from a report

Hi,I am trying to come up to speed on extracting values from a report called by a script.To test things out I create two simple columns and do a fit and I am trying to extract the intercept from the estimate just so I know what I am doing.Test=Bivariate( Y( :Column 2 ), X( :Column 1 ), Fit Line( {Line Color( {208, 64, 86} )} ));r=test<<report;fred=r[outlinebox("Linear Fit"),Outlinebox("Paramete...
Hegedus

Discussions |
Jul 16, 2020 10:38 PM

9617 views | 10 replies
Fit model using stepwise method

Hi,In the context of my PhD, I'm doing a Fit model using stepwise method to determine the set of factors that best explain my variable of interest (energy balance). When I click on GO this alert message appear: ALERT: Failed to converge (step-halving limit). I have put 50 variables in the construct model effect box. Then I clicked on RUN. I choose my stopping rule and direction and clicked on GO....
audreystlo

Discussions |
Jul 16, 2020 9:34 AM

1959 views | 1 replies
Is there a way to display 95th, 90th 75th, 50th, 25th, 10th and 5th percentiles in box plots in graph builder or one way plots

In my work we display 95th, 90th 75th, 50th, 25th, 10th and 5th percentiles + the mean in our box plots in excel (which is painful and time consuming) – is there a way of replicating this in JMP oneway or graph builder? andrew.botfield@geochemistry.com.au
Andrew_Botfield

Discussions |
Jul 15, 2020 4:28 PM

6627 views | 8 replies

Previous
Next

Latest Discussions

[JSL Contour Plot] Method of define contour plot, number, minimum, maximum

The contour plot is very helpful to show 3D map, however the problem of defining the zone is always a trouble. In my typical jsl plot, I use something below to define the contour plot zone number = 8, maximum = 1.4, minimum =1. However, the table column :Length may change time to time, and the scale will have to be modified manually for each corresponding plot. Does someone have experience how t...
Stokes

Discussions |
Jun 25, 2020 12:09 PM

1288 views | 0 replies
Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

1309 views | 0 replies
How do I have two different chart types in a single graph using two axis?

While doing some research to answer this question, I found this article on the JMP community that helped me get started. How do I do a combination bar and line plot using Overlay Plot? Using the big class sample data example of height and weight I was able to create a bar chart for weight and a line plot for height on the same chart using the Overlay Plot. To do this, first clear the row s...
Bass_Masri

Discussions |
Apr 28, 2020 4:28 PM

4657 views | 0 replies
How do I calculate z-scores at different aggregation levels?

Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county-level. I need to calculate Z-scores to compare each county to the others within a state and all counties within the country. I cannot simply use the standardize function because it automatically takes an average of rates--which is invalid unless the...
Jmsouch

Discussions |
Feb 26, 2020 7:04 AM

2212 views | 0 replies
Calling Windows API ImageViewer.dll to display JPG files.

I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I have been able to get the following code to load the DLL but get an error requesting a signature argument. Does anyone know how to get a signature string from the system to pass to the DLL. ERROR MESSAGE FORM LOG: Second argument to CallDLL must be a ...
DMeakin1

Discussions |
Jan 17, 2020 10:19 AM

2016 views | 0 replies