JMP User Community

Latest Discussions

How to use data filter for a column with empty cells without deleting the cells?

Hi I want to make a filter in my report for a column that has a few empty cells. Other cells have the name of products. When I use Data Filter, nothing shows up in the report and I think it is because of empty cells. I tried to exclude them but did not work Add Filter( columns( :Entity1, :Entity2, Where( :Entity1 != "" ), Where( :Entity2 != "" ), ), Display( :Entity1, Size( 120, 100 )...
Mikasa

Discussions |
Sep 13, 2020 10:35 AM

2891 views | 4 replies
Questions about "number of starts" and "search time"

Could anyone help me understand "number of starts" and "search time"? 1. Will increase "number of starts" or use much longer "search time" provide a better optimal design?2. What is a good guess for "number of starts"? i.e., let us say a split-plot design with 5 whole plots and 25 subplots. Thanks!
Jeff2010

Discussions |
Sep 13, 2020 8:08 AM

1910 views | 2 replies
Import only a part of a large csv file to JMP

I have a large csv file containing > 50million rows of data for all 50 states of the US. How can I import only part of the data to JMP (e.g., data for California only)?One way to do it is to open the cvs file in JMP and then filter out the data for California, but this takes forever. So I was wondering if there is a way to filter the data *before* importing it to JMP? I guess this can be done with...
shasheminassab

Discussions |
Sep 12, 2020 5:25 PM

1849 views | 1 replies
Graph Builder "Copy Graph" button

Why is there no "Copy Graph" button in Graph Builder? It seems like the most intuitive thing to have in the interface because in almost every case (for us at least), once we have a graph we like, we want to copy/paste it to PowerPoint, Word, etc. I was going to post this the other day, but then I thought -- what if just ctrl-c (cmd-c) copied the graph. So I tried it and it worked! But when I wen...
BHarris

Discussions |
Sep 11, 2020 2:27 PM

9070 views | 4 replies
duplicating elements in list

What's the easiest way to duplicate elements in a list myListA = {"y"}; //Result I need: myList = {"y", "y"}; // This should work with an arbitrary number of elements in the list myListB = {"y1", "y2", "y3"}; //Results myList = {"y1", "y2", "y3","y1", "y2", "y3"};
FN

Discussions |
Sep 11, 2020 11:43 AM

2228 views | 3 replies

Previous
Next

Latest Discussions

How to use data filter for a column with empty cells without deleting the cells?

Hi I want to make a filter in my report for a column that has a few empty cells. Other cells have the name of products. When I use Data Filter, nothing shows up in the report and I think it is because of empty cells. I tried to exclude them but did not work Add Filter( columns( :Entity1, :Entity2, Where( :Entity1 != "" ), Where( :Entity2 != "" ), ), Display( :Entity1, Size( 120, 100 )...
Mikasa

Discussions |
Sep 13, 2020 10:35 AM

2891 views | 4 replies
Import only a part of a large csv file to JMP

I have a large csv file containing > 50million rows of data for all 50 states of the US. How can I import only part of the data to JMP (e.g., data for California only)?One way to do it is to open the cvs file in JMP and then filter out the data for California, but this takes forever. So I was wondering if there is a way to filter the data *before* importing it to JMP? I guess this can be done with...
shasheminassab

Discussions |
Sep 12, 2020 5:25 PM

1849 views | 1 replies
Graph Builder "Copy Graph" button

Why is there no "Copy Graph" button in Graph Builder? It seems like the most intuitive thing to have in the interface because in almost every case (for us at least), once we have a graph we like, we want to copy/paste it to PowerPoint, Word, etc. I was going to post this the other day, but then I thought -- what if just ctrl-c (cmd-c) copied the graph. So I tried it and it worked! But when I wen...
BHarris

Discussions |
Sep 11, 2020 2:27 PM

9070 views | 4 replies
How to change legend names in JSL (in Graph Builder)?

I get a lot of data in a CSV file (many columns, many rows) and am working on a basic template in JSL to standardise the generation of graphs. (Rescaling the axes, renaming the axes, standardising the colour of the lines etc...) On the average I can get one CSV file per day so I want to put the data into a JMP Data table, run the script and have the graph output all automated.My JMP file has by de...
scottahindle

Discussions |
Sep 10, 2020 5:09 AM

10496 views | 9 replies
Tolerance Interval for Regression

Is there a way to calculate the tolerance interval for a simple univariate regression in JMP? There is only prediction and confidence intervals options available. Thanks
nguyendv0610

Discussions |
Sep 10, 2020 2:15 AM

1960 views | 1 replies

Previous
Next

Latest Discussions

Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1404 views | 0 replies
order statistic for DS Weibull ... maximum failure time for n fails out of N~n/p units

this isn't a JMP question per se, but a reliability/survival statistics question ... see my post on Cross Validatedthanks in advance! :)https://stats.stackexchange.com/questions/483556/order-statistic-maximum-for-subpopulation-weibull-distribution
galactus3000

Discussions |
Aug 18, 2020 8:48 AM

986 views | 0 replies
Custom Lat Long Contour Map

Hi all, Playing around with the Custom Map Creator add in and I ran into some trouble when trying to construct borders for a river system. When constructing a custom map border using a a background map the boundaries function does not let me to trace the river pattern as accurately as I would hope (see attached photo). Alternatively, when constructing a border from a background photo the bounda...
MikeDereviankin

Discussions |
Aug 14, 2020 11:03 AM

1101 views | 0 replies
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

1487 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

1694 views | 0 replies