JMP User Community

Latest Discussions

Comparing all pairs within groups

Hi, I´m looking for some inspiration on how to approach a data set. I´m looking at demographics data for a group of people where I need to identify potential duplicate persons. Some parts of the data are accurate (birth date, sex, country) and other parts are not (height, weight). This means, that even though height & weight is not identical for two persons, they can actually be the same. So withi...
JulieSAppel

Discussions |
Jul 10, 2020 4:34 AM

1977 views | 2 replies
Updating JMP table from SharePoint list / document library

Hi there, used the search functionality but did not find a related topic, please correct me if I am wrong. We have different SharePoint lists and libraries which I would like to update my evaluation automatically with updated content from the SharePoint.I was able to download data using Open("https://SHAREPOINT-ADDRESS/AllItems.aspx", HTML Table( 1, Column Names( 1 ), Data Starts( 2 ) )) This w...
ubpk

Discussions |
Jul 10, 2020 3:56 AM

2494 views | 1 replies
Close data table before stop() gives I/O problem

Hello, I'm receiving this errorI/O problem.
Unable to open in ReadWrite mode.
The system cannot find the file specified.Test.jmpWhen I run a script like this.dt = Open Database( connection, query, "Test" ); list = :aColumn << Get Stored Values; selection = Expr( window = New Window ("Selection", <<Modal, PanelBox("Selection", rbox = RadioBox( list, value = rbox << Get Selected;),...
Herrera5238

Discussions |
Jul 9, 2020 1:36 PM

1821 views | 1 replies
Report out of control point from control chart

I have control chart that applied test 1,2,5, and 6. There are some data point failed this limit.I use alarm script and be able to get the message in the log. How can I send that message to the new table ?
yanee

Discussions |
Jul 9, 2020 12:38 PM

3069 views | 4 replies
How to keep numeric data from changing to scientific notation during import from Excel file

Hello, I am importing data from an Excel file. My data becomes scientific notation and then I lose the details from the last two digits. How can I import numbers from an Excel file so that JMP does not change the format to scientific notation? Here is an example of the data: Number2016060914410870120160609144108702201606091441087032016060914410870420160609144108705201606091441087062016060914410870...
Wende

Discussions |
Jul 8, 2020 11:16 PM

11031 views | 5 replies

Previous
Next

Latest Discussions

Comparing all pairs within groups

Hi, I´m looking for some inspiration on how to approach a data set. I´m looking at demographics data for a group of people where I need to identify potential duplicate persons. Some parts of the data are accurate (birth date, sex, country) and other parts are not (height, weight). This means, that even though height & weight is not identical for two persons, they can actually be the same. So withi...
JulieSAppel

Discussions |
Jul 10, 2020 4:34 AM

1977 views | 2 replies
How do I add the percent total value as a text label on a Tree Map?

Hi everyone, This seems like it should be a very easy thing to do, but I can't figure out how to add the percent total value (which is available on the hover tip) as a text label (under the exact value label) in each panel of the actual Tree Map. I'd like to do this so that I can share static charts with people who don't have JMP and can't use the hover tip. Thanks for any solutions.
caseylott

Discussions |
Jul 8, 2020 10:47 AM

4795 views | 3 replies
Auto-correlation in multi-linear regression model with time-dependent variable

Hi all, I'm trying to generate a multi-linear regression model on a study that spanned many weeks. One of the factors is cell age and this does seem to have a significant effect on the response. When looking at Residuals vs Row plot and performing Durbin-Watson test, it looks like the data are not independent (i.e. auto-correlation exists). However, since cell age is a time-dependent factor, would...
hxnduke

Discussions |
Jul 7, 2020 2:22 PM

4543 views | 6 replies
Graph Builder: How do I reduce spacing between bars?

I've got the following graph, in which width and spacing in the two panels (experiments here) are automatically set so that the two panels are the same size. i want both panels to have the same bars widths and spacing (which would make the right panel narrower than the left) i've here changed bar widths in the right panel (customize > bar > width proportion) to match those on the left and i now w...
jac865

Discussions |
Jul 7, 2020 1:40 PM

4554 views | 4 replies
which distance does JMP use in clustering?

Hello everybody.I'm trying to understand which distance does JMP use in hierarchical clustering: the documentation in https://www.jmp.com/support/help/en/15.1/index.shtml#page/jmp/distance-method-formulas.shtml#ww177809 seems to say "squared euclidean distance" but if I save the distance matrix (after clustering) what I get is the euclidean distance (not squared).And what about the k-means method?...
francesco_della

Discussions |
Jul 7, 2020 7:43 AM

3319 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

1190 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

1170 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

4425 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

2036 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

1882 views | 0 replies