JMP User Community

Latest Discussions

Change drawing order of graphics elements using JSL

Hi All,I know you can change the drawing order of graphics elements by right clicking on a graph, then clicking customize, and then moving the order of the graphics scripts using the up/down arrows. Is there a way to do this using JSL? There are messages you can send to the Framebox to change the order of grid lines and reference lines, I was hoping there would be something similar for markers. Al...
nkelleh

Discussions |
Sep 1, 2020 8:52 AM

17888 views | 7 replies
Local Data Filter and Moving X-axis

Hi, when I use time as a variable for the local data filter in the graph builder platform, then while changing the time, the x-axis adapts automatically to the slected time frame. This means that only the selected data are shown in the graph. When I use time as a variable for the local data filter in the contol chart builder platform, then while changing the time, the x-axis remains static. Is it ...
Konstantinos

Discussions |
Sep 1, 2020 5:47 AM

3560 views | 6 replies
Fit Model - Custom Test

Hello everybody,I have a question regarding the Fit Model platform. Let's say that I am working with the Big Class data table. My Y variable is height and I have two effects in my model: age and sex.I would like to know if the height difference between the groups 12 and 17 for M is significantly different from the height difference between the groups 12 and 17 for F. I think I can use the "Custom ...
anne_sa

Discussions |
Aug 31, 2020 11:34 PM

6264 views | 8 replies
List the value for Max Date?

I have a data table that has a date column, median_resultval column and reagentMLot_sublot . What I would like is that for the Max(Date) what is the value by reagentMLot_sublot. So for each reagentMLot_sublot I would like to list the median_result value for the Max Date and the median_result for the min date. So if on the min day the median value is 0.1 and on the max day it is 0.2 I would like...
UberBock

Discussions |
Aug 31, 2020 8:03 PM

5760 views | 9 replies
UPDATE JOIN SQL statement with JMP tables

Hi, I would like to update via SQL statement the :age column in dt1 with the values of dt2. dt1 = Open( "$SAMPLE_DATA/Big Class.jmp", output table("t1")); dt2 = subset(dt1); dt2:age[1] = 99; Query( Table( dt1, "t1" ), Table( dt2, "t2" ), "\[ UPDATE t1 SET t1.age = t2.age FROM t1 INNER JOIN t2 ON t1.name = t2.name ]\" );I got an syntax error near "." Thanks
TWE

Discussions |
Aug 30, 2020 11:23 PM

2298 views | 2 replies

Previous
Next

Latest Discussions

Local Data Filter and Moving X-axis

Hi, when I use time as a variable for the local data filter in the graph builder platform, then while changing the time, the x-axis adapts automatically to the slected time frame. This means that only the selected data are shown in the graph. When I use time as a variable for the local data filter in the contol chart builder platform, then while changing the time, the x-axis remains static. Is it ...
Konstantinos

Discussions |
Sep 1, 2020 5:47 AM

3560 views | 6 replies
List the value for Max Date?

I have a data table that has a date column, median_resultval column and reagentMLot_sublot . What I would like is that for the Max(Date) what is the value by reagentMLot_sublot. So for each reagentMLot_sublot I would like to list the median_result value for the Max Date and the median_result for the min date. So if on the min day the median value is 0.1 and on the max day it is 0.2 I would like...
UberBock

Discussions |
Aug 31, 2020 8:03 PM

5760 views | 9 replies
Partition Modelling: What dictates Minimum Size Split?

I am not a de facto statistician but have gained much experience in biostatistics over many years, thanks largely to using the standard version of JMP (currently v13). I certainly cannot imagine using anything else and regularly promote it.I am presently progressively defining partitions in a variety of continuous variables to optimise outcome in a binomial categorical variable (fail versus pass)....
34South

Discussions |
Aug 30, 2020 2:02 PM

4812 views | 4 replies
How to save a file with name as a variable in For loop to save multiple files

Hi, I am trying to save files in a for loop, the problem is how to put a variable into the file saving procedure, However, it looks the file save part is not working. I didn't use any clear global to make sure filename has be assigned with the original value. Is there any problem with my saving part? Thanks // filename is a variable assigned below, For( j = 1, j <= N Row( sdt ), j++, filename...
Stokes

Discussions |
Aug 28, 2020 4:29 PM

3184 views | 2 replies
How to get lowest two row values in grouped data ?

Hi, Lets say we have data like this and want to get lowest two row values. Group by Age and Sex, get the two lowest height values. How can we do this in JSL? Thanks
joshua

Discussions |
Aug 27, 2020 11:44 AM

1752 views | 1 replies

Previous
Next

Latest Discussions

order statistic for DS Weibull ... maximum failure time for n fails out of N~n/p units

this isn't a JMP question per se, but a reliability/survival statistics question ... see my post on Cross Validatedthanks in advance! :)https://stats.stackexchange.com/questions/483556/order-statistic-maximum-for-subpopulation-weibull-distribution
galactus3000

Discussions |
Aug 18, 2020 8:48 AM

1015 views | 0 replies
Custom Lat Long Contour Map

Hi all, Playing around with the Custom Map Creator add in and I ran into some trouble when trying to construct borders for a river system. When constructing a custom map border using a a background map the boundaries function does not let me to trace the river pattern as accurately as I would hope (see attached photo). Alternatively, when constructing a border from a background photo the bounda...
MikeDereviankin

Discussions |
Aug 14, 2020 11:03 AM

1141 views | 0 replies
XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

1544 views | 0 replies
Using JMP to Calculate Surface Flatness

Has anyone used JMP to calculate the Minimum Zone surface flatness of a point cloud? I have some differences between two metrology areas for our surface flatness requirements and wanted to check them in JMP. There are different algorithms for doing the calculation. (There is an ASME standard for the general rule, ASME Y14.5: " a tolerance zone defined by two parallel planes within which the surfa...
jay_holavarri

Discussions |
Jul 20, 2020 11:26 AM

1736 views | 0 replies
Save all scripts and close reports by JSL

Trying to write a script for this I found the following below working. JMP15@Win10.The first part opens two tables and starts some Reports,and the second Closes all report Windows post saving scripts to belonging tables.But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference).Is there a way to find proper reference for e...
Georg

Discussions |
Jul 20, 2020 7:48 AM

1458 views | 0 replies