JMP User Community

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

3389 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

4637 views | 5 replies
Minitab and JMP: different results for CPK in Lognormal data

Dears,in this moment I'm evaluating a set of data.This data are lognormal distributed.I perform the CPK analysis wiht JMP and with Minitab: the capability resutl is different.Some one of you, knonw the reason?I think it could be linked to the type of formula usage for capability calculation... but I'm not sure. Thanks in advance for the feedback.Best regards,Simone
Simone1

Discussions |
Jun 30, 2020 12:10 PM

13091 views | 16 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

3330 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

3642 views | 7 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

3389 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

3330 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

3642 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

4367 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

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

1171 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

4429 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

1883 views | 0 replies