JMP User Community

Latest Discussions

Get Excel Worksheets XLSM

I am trying to use the Get Excel Worksheets function on a Macro Enabled Excel file (.xlsm) and can't seem to get it to work. I saved the same file as a regular .xlsx and it worked like a charm with that. The Scripting Index doesn't really mention any condition of excel file type... Is this function just not compatible with .xlsm?
dconradgreen

Discussions |
Aug 18, 2020 5:58 AM

2903 views | 2 replies
Why can't this JSL run in JMP15?

The following JSL build validation operation(Make Validation Column) with JMP 15 has an error.But this code works fine in version 14. dt = Current Data Table(); dt<<Make Validation Column(Training Set(0.34),Validation Set(0.33),Test Set(0.33),Cutpoint(:code));
How to modify JSL, thank you!
lwx228

Discussions |
Aug 18, 2020 3:47 AM

2569 views | 4 replies
How to call an add in using a script in jrn

Hi, I'm new and need some help. I've learn how to create script button at jrn and manage to automate t test comparison manually. However, I already had addin Data Comparison which is much more easier for me. Somehow I want to make the script button to open the addin selection. my current jrn button script is like this, it open from origin path of addin (view -> home folder jsl)I read somewhere in ...
tikhahabusamah

Discussions |
Aug 17, 2020 7:22 PM

4074 views | 7 replies
Violin plot with gradient

Hello all, I have a continuous variable that I would like to display where the more frequent entries cause the plot to be wider and have a gradient of colors from the min-max of the data range. I can create a scatter point plot that is CLOSE to what I want (not sure why the gradient colors are faded). To get there, I drag the variable to the Y axis and then also drag that same variable to the "Col...
darkzero901

Discussions |
Aug 17, 2020 12:09 PM

2145 views | 2 replies
Iterate over elements of report

Hi, I'm new using JMP but I find it very useful and practical, so far I'm enjoying it a lot. I’m learning JSL because I need to automatize some of the analysis for my teammates and for efficiency. I am starting with something simple but I need help to move forward. I need to customize the results of the distribution platform to perform a test of normality for several columns of a table, in order t...
teoten

Discussions |
Aug 17, 2020 7:03 AM

3161 views | 4 replies

Previous
Next

Latest Discussions

Violin plot with gradient

Hello all, I have a continuous variable that I would like to display where the more frequent entries cause the plot to be wider and have a gradient of colors from the min-max of the data range. I can create a scatter point plot that is CLOSE to what I want (not sure why the gradient colors are faded). To get there, I drag the variable to the Y axis and then also drag that same variable to the "Col...
darkzero901

Discussions |
Aug 17, 2020 12:09 PM

2145 views | 2 replies
exclude but not hide data in graphs and/or copy frame contents results disappearing

Hi, I am looking for a way to exclude rows from calculations, but not hide them in graphs, preferably using the GUI/graphbuilder.Specifically, I want 1 or more baseline samples to be displayed in a graph, but not have them be part of the line of fit or any future linear regression calculations. One solution would be to filter out this data with a local data filter, do the line of fit, and add the ...
PedeGe

Discussions |
Aug 17, 2020 12:20 AM

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

1003 views | 0 replies
JMP 12 interface slow, especially with new 4k monitor

I am using JMP 12 at my work, and the interface has always been a little laggy. Recently I've upgraded to a new 4k monitor, and everything scales well and works well except that JMP is now very slow. This includes scrolling through open Data Tables, scrolling through UI elements, and in general anything JMP's native UI engine. I've seen the post about graphics hardware acceleration for JMP 13, ...
LaserRasin

Discussions |
Aug 14, 2020 10:36 AM

2432 views | 2 replies
JMP Control Chart Phase/Axis Organization

Hello! I recently am struggling with an issue in Control Charts. I have data organized by date with two main phases. Essentially, I want to be able to overlay the phases because in my data I go from phase A, to phase B, then back to phase A over time. By default JMP will separate my phases, then sort by date. This means the data is not in order by date, and all my phase B data is placed after phas...
Cwalla

Discussions |
Aug 14, 2020 10:24 AM

4936 views | 3 replies

Previous
Next

Latest Discussions

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

1003 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

1315 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

1560 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

1312 views | 0 replies
[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

1190 views | 0 replies