JMP User Community

Latest Discussions

Updating picture links in a PowerPoint document using JSL and VBA

I am working on an add-in to automate some reporting. There is a report template PowerPoint file that includes links to image files of various charts and tables. (see attched)When the user clicks the "add to active report" button, the appropriate image file will be overwritten so that the new chart or table will show up in the report.The problem I am having is that I need to update the links in th...
johnmoore

Discussions |
Sep 3, 2020 7:10 AM

2462 views | 1 replies
get rows two weeks before today's date

Hello, In a script, I would like to be able to select rows that are two weeks before today's date.I would like to run the script and depending on what day it is, that JMP displays the last two weeks only. For that I used in my script the function "subset" and the function :"get rows where" (: A> 40 &: A <59.5), and I would like to add something else to select the rows corresponding to two weeks be...
Emma1

Discussions |
Sep 3, 2020 6:21 AM

2970 views | 9 replies
How do I automatically add all columns to the Column Switcher in .jsl

I'm very much a beginner with JSL, I'm still learning -- I have many files that I need to review with Graph Builder, and each has a different number of columns. The only constant is that I know I want column 1 as the Overlay, column 2 in the X-axis, column 3 in the Y-axis, and all the rest of the columns in the Column Switcher. I'd love to have a script that would open up all the Graph Builder w...
BHarris

Discussions |
Sep 2, 2020 3:18 PM

4647 views | 10 replies
Add levels to an augmented design

Hi, I would like to adopt an existing design. The current design has four factors with two levels. Now I would like to add at least one or two levels to two factors.
Is it possible to use augment design or is there another way? Until now I found no answer to adopt the design.
Best regards, Andre!
A_Huber

Discussions |
Sep 2, 2020 12:30 PM

1619 views | 3 replies
Using an OR statement in selecting rows for exclusion

I am a JSL newbie ...I want to select rows and then hide and exclude based on two criteria using an OR statement. I want to select when 'comment' is blank or when Excluded Sum < 2. I can get both conditions to work independently but when I combine them with an OR statement, no rows are selected. I have also tried current selection ("extend") with the same result. I am using JMP 15.2.0 dt =Curr...
jcminor

Discussions |
Sep 2, 2020 11:32 AM

2893 views | 6 replies

Previous
Next

Latest Discussions

Add levels to an augmented design

Hi, I would like to adopt an existing design. The current design has four factors with two levels. Now I would like to add at least one or two levels to two factors.
Is it possible to use augment design or is there another way? Until now I found no answer to adopt the design.
Best regards, Andre!
A_Huber

Discussions |
Sep 2, 2020 12:30 PM

1619 views | 3 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

2519 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

3995 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

3110 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

2356 views | 2 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

717 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

801 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

975 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

1269 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

1122 views | 0 replies