JMP User Community

Latest Discussions

Create a numeric, ordinal, best (12), format = ("m\y" ) "Mon-Yr" column from a pre-existing character column with "Mon-Yr" = "01/2020"

I have a pre-existing character "Year" column for example "K001/2020", "K002/2020", "K003/2020", etc. Using script I'm able to create a new character "Mon-Yr" column = "01/2020", "02/2020", "03/2020", etc. [ I used the formula substring ("Year", <4,7>) to do this. ] What JMP script can I use to convert the character "01/2020", "02/2020", "03/2020", etc. to numeric, ordinal, best (12), format ("...
fuscod

Discussions |
Jul 28, 2020 8:09 PM

4511 views | 8 replies
How to save journal as PPT (2 graphs per slide) using JSL

Hello users,I am trying to save a journal as powerpoint. I would like to save 2 graphs per powerpoint slide instead of just one.Right now I get 1 graph per slide. I want 2 graphs per slide. How do I go about doing that using JSL? My JSL script is: Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Fitness.jmp" ); obj = Logistic( Y( :Name ), X( :RstPulse ), By( :Age) ); obj << journal; Current J...
simon_2

Discussions |
Jul 28, 2020 7:52 PM

4417 views | 2 replies
Prediction profiller and simulation

Could you explain what the Black box behind prediction profiller and how it Suggests a solution when we use maximum desirability?
Ella

Discussions |
Jul 28, 2020 2:16 PM

3853 views | 8 replies
New Create Column with filling fixed value

Kindly help to suggest how to New Create Column with filling fixed value, thanks a lot. table I only have one column called "name" Table II new create two columns and fill in fixed value.
qspringleaf

Discussions |
Jul 28, 2020 1:44 PM

5015 views | 4 replies
Coloring dot distributions indvidually by "Value Colors" property (or alternative)

I would like to plot the data distributions but coloring each variable individually. Example: I found the following property which encodes color base on max/min gradient or user specific data. However, this might not the be the right approach. The code for the example which I manually composed to explain the goal is here:// Start of script; Names Default To Here( 1 ); Clear Log(); dt = Open( "$S...
FN

Discussions |
Jul 28, 2020 10:33 AM

2893 views | 4 replies

Previous
Next

Latest Discussions

Prediction profiller and simulation

Could you explain what the Black box behind prediction profiller and how it Suggests a solution when we use maximum desirability?
Ella

Discussions |
Jul 28, 2020 2:16 PM

3853 views | 8 replies
Standard betas for logistic regression

I would like to compare strength of effect in my logistic regression model. In least squares models I can bring up and compare standardized beta coefficients. Can this be done with logistic models? (I don't see the option in "columns" option). Or, is there another method to compare the strength of effect of each of my terms in the model? ThanksFishguy
fishguy

Discussions |
Jul 28, 2020 8:27 AM

4795 views | 4 replies
Loop for opening files, changing a column name and saving in the original format

Hello all, I've tried to assemble a script for opening a series of files (.dx) and changing the text from one of the columns on each file. I manage to make it work for one or two files individually but if I try a set of four an infinite loop begins. Can anybody please help? There is a chance that the issue is with the files but I would like to vet the script first since I'm a novice at jsl. Ideall...
vmontes

Discussions |
Jul 27, 2020 6:49 PM

3182 views | 4 replies
JSL Options for Reordering Columns Numerically

Are there any options for reordering columns in JSL beyond "Reorder by Name, Modeling Type, Data Type"?

I'm looking to reorder some columns with names and numerical indexing. The columns are named in the following manner- "Column Data 1 (1), Column Data 1 (2), ...., Column Data 99 (1), Column Data 99 (2),...".

Using the reorder by name option basically reorders the data (1), (100), (101), (102),.. o...
ctwede

Discussions |
Jul 27, 2020 6:11 PM

2373 views | 2 replies
Running count formula

I have a column with data that is either a 0 or 1. I would like to have a running total down the table of the amount of times it is a 1 in a separate column. How do I do this?
cdburton

Discussions |
Jul 27, 2020 2:43 PM

1815 views | 1 replies

Previous
Next

Latest Discussions

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

1490 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

1695 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

1422 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

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

1314 views | 0 replies