JMP User Community

Latest Discussions

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

9618 views | 10 replies
Graph Builder Charts By Variable with different Y axis scales

All, I need to modify my Scripted Graph Builder so that it sets various scales for each plot.I have a table of the (simplified) form::date - just a date:rawValue - some numeric value:byVariable - several categorical values to separate :rawValues into groups:rawMedian - just a median value for each of the groups, formula Col Quantile(:rawValue, 0.5, :byVariable) I plot it this way: Graph Builder( S...
miguello

Discussions |
Jul 16, 2020 3:24 PM

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

1961 views | 1 replies
How do I display multiple ROC curves on the same graph?

Hello everyone,
I am trying to develop a test to distinguish between two groups (0 and 1). There are two tests A and B have different ROC curves which I have been able to plot individually. However I want to generate a graph that displays the ROC curves for A, B and A*B in the same panel. Can anyone help me with this?

Discussions |
Jul 16, 2020 8:57 AM

13555 views | 5 replies
How to count two terms as one Text Explorer?

Hi,In Text Explorer section, I have several different words that relate to the same idea, but I can't count them as a single element. For example: 77 occurrences for the word "Christ" and 55 for the word "Jesus"; or 100 occurrences for "painting" and 50 for "canvas". Jesus/Christ and Painting/Canvas is the same idea in my study, so I would like to aggregate them as one. I would like JMP to count t...
pablosfontoura

Discussions |
Jul 16, 2020 7:49 AM

1828 views | 1 replies

Previous
Next

Latest Discussions

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

9618 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

1961 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
Get XML Elements

Hi, I am trying to read and XML file with a structure similar to the snippet below. <Top Element>
<Element 1>True</Element 1>
<Element 2>True</Element 2>
<Element 3>False</Element 3>
</Top Element> I know how to use the Parse XML by calling out the element names but in the document I have there are hundreds of different element names that I don't want to call out specifically in my code. I ...
Brandon

Discussions |
Jul 15, 2020 1:40 PM

2787 views | 3 replies
simple copy paste frm jmp to Excel not happening completely

HiHelp! Please let know if this is some kind of a bug: I just tried to do a super simple copy paste of 2000 cells in a column in jmp to Excel and only 1600 get pasted in ExcelThe same operation has no issue for other two columns where all 2000 cells get pasted.Thanks
kanchanjoshi

Discussions |
Jul 14, 2020 10:11 PM

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

2213 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

2019 views | 0 replies