JMP User Community

Latest Discussions

Select Where evaluation using a variable

I'm having a strange issue when trying to use a variable in Select Where(). The following code works fine:dt << Row Selection( Select Where( df:TestName != "pb" & df:BoType=="xxxx") ); Show(nrows(dt << get selected rows));Prints in Log: Number of selected rows > 0 as expected. But the following code fails completely:sb="xxxx"; dt << Row Selection( Select Where( df:TestName != "pb" & df:BoType==sb)...
buchea

Discussions |
Jul 1, 2020 12:52 PM

1771 views | 2 replies
displaying probability value of two data set in a single probability plot

Hi ,I am having 2 data set into 2 different data tables, i want to compare the probability values of both the data set into single probability plot. is there any way to do that? Regards,Dilip
dilipkumar

Discussions |
Jul 1, 2020 9:54 AM

2453 views | 3 replies
Continuous variable as independent variable and covariate

Hi there,I am trying to understand how do we define continuous variable as independent or covariate in JMP, in term of using them in fit model platform.My current understanding is, unless one define design role as covariate to continuous variable, it is independent. And, Model significance test, based on F-test, is called as ANOVA.If continuous variable is defined as covariate, model significance...
nil

Discussions |
Jul 1, 2020 6:18 AM

4194 views | 3 replies
Remove columns from a table

Hi everybody, I need to export several tables (txt files containing 20 columns) under JMP, but only 10 columns are useful for my use.How can I include in a script the deleting of specified columns? I have attached one example file: (1) the txt source (2) the JMP version with all columns (3) the final JMP version with 10 columns. Thanks in advance, Paul
paul_apicella

Discussions |
Jul 1, 2020 3:29 AM

3396 views | 2 replies
Returning value for one column based on reference from other column

Hi All I have the columns "Rel Interval", "SrID", "Pass_Fail". I want to create and generate script for the last column "Updated Pass_Fail_SrID". All SrID are passing at rel interval "0" and "24" but SrID "B" and "D" fail at "100". I want to create last column "Updated Pass_Fail_SrID" which takes reference of pass and fail and assigns pass / fail to all checkpoints. This is so that while plotting ...
sbidwe

Discussions |
Jun 30, 2020 10:13 PM

4641 views | 5 replies

Previous
Next

Latest Discussions

Remove columns from a table

Hi everybody, I need to export several tables (txt files containing 20 columns) under JMP, but only 10 columns are useful for my use.How can I include in a script the deleting of specified columns? I have attached one example file: (1) the txt source (2) the JMP version with all columns (3) the final JMP version with 10 columns. Thanks in advance, Paul
paul_apicella

Discussions |
Jul 1, 2020 3:29 AM

3396 views | 2 replies
How to add percentages for each slice in a pie chart

Hi, I am trying to add percentages to each slice in my pie chart using graph builder with no success. I've tried playing with the summary statistic options shown in the bottom left in the screenshot with no luck. Why aren't the percentages showing up? How can I display them? Thanks in advance!
jmpvmd

Discussions |
Jun 30, 2020 8:57 AM

3333 views | 4 replies
Can JMP show custom Mapbox as background map?

I created a custom map on Mapbox and used its URL in the Web Map Service of Graph Builder but nothing showed up. Can JMP actually show custom Mapbox as background map?
shasheminassab

Discussions |
Jun 30, 2020 4:37 AM

3647 views | 7 replies
Label multiple images to show in graph

When a column with images is set as a label, hovering over a datapoint in a graph shows the resp. image. Is it possible to do this for multiple images (in different columns)? Setting several columns as label doesn't work, only the image of the first column is shown.
gandi2223

Discussions |
Jun 29, 2020 6:43 PM

7327 views | 5 replies
Exporting a JMP Data Table in JSON Format

Hi,
I've been asked whether it's possible for JMP to export a data table in JSON format, where everything contained within that data table - including all table properties and formulae - can be exported in such a way that it can be retrieved (if necessary by coding in another language) by someone else who doesn't necessarily have access to JMP. I've already taken a look at the post below on this fo...
DMR

Discussions |
Jun 29, 2020 1:52 PM

4368 views | 5 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

1194 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

1174 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

4434 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

2038 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

1885 views | 0 replies