JMP User Community

Latest Discussions

From Python Pandas dataframe to jmp with group columns and add column property

Hello there,I have a table that is a generate from a collection of databases.Columns = [Time, raw1_prop1, raw1_prop2, raw1_prop1,..., Q1] The table is the same format every time and would therefore like to:Group column by front name meaning raw1's are grouped and raw2's are groupGive Q1 the column property: Spec limits + Show on graph bitI would prefer to do it from python but i can also be tricke...
qLienceStats

Discussions |
Oct 22, 2020 11:19 AM

2132 views | 1 replies
Augmented design with diffrent optimality criteria

Dear all,

I have 4 continuous factors. I made an custom Design with recommended optimality which is d for a model containing main effects, 2nd order interractions and 2nd order powers. I run 80 Experiments and use least square estimate for linear model. Then i see that i have to include 3rd order powers to my model and i made augmented Design with I optimality by including 3rd order powers to my mo...
Ella

Discussions |
Oct 22, 2020 9:18 AM

2860 views | 3 replies
DOE results analysis

HiI was analyzing the results of a DOE with 5 factors moved up and down wrt set values. The response Y is a measured resistance.I ran a fit model by using a full factorial and then a stepwise regression. The stopping rule was Min BIC and direction: forward. Once selected the suggested factors I made the model and ran it. The R2 was very good as also the profilers. Anyway if I look at residuals th...
FR60

Discussions |
Oct 22, 2020 7:06 AM

2444 views | 3 replies
Percentual plot

Hello everybody, I plotted some data and divided the plot into two parts. One for "good" and one for "bad" - green and red columns. Is there a possibility to add a third part in the plot which displays the percentual "bad" values for the total values of the x-axis? See Images attached. Thank you.
JohannesENS

Discussions |
Oct 22, 2020 7:01 AM

2464 views | 1 replies
PostgreSQL function: is it a bug?

Hi,I have a problem with queries on a PostgreSQL database using the JMP query builder...
Indeed some PostgreSQL functions seem not working properly in the query builder...For example if I want to retrieve part of a string from the position of one of the character:
this command could ben written in PostgreSQL:SELECT substring('Thomas' from position('h' in 'Thomas') for 2) AS bug_test But if I write i...
Franck_R

Discussions |
Oct 22, 2020 5:56 AM

1869 views | 2 replies

Previous
Next

Latest Discussions

PostgreSQL function: is it a bug?

Hi,I have a problem with queries on a PostgreSQL database using the JMP query builder...
Indeed some PostgreSQL functions seem not working properly in the query builder...For example if I want to retrieve part of a string from the position of one of the character:
this command could ben written in PostgreSQL:SELECT substring('Thomas' from position('h' in 'Thomas') for 2) AS bug_test But if I write i...
Franck_R

Discussions |
Oct 22, 2020 5:56 AM

1869 views | 2 replies
How to close database connection after running a New Sql Query?

Steps to reproduce: Run any new sql query: query << Run Foreground( OnRunComplete( Write( "Number of rows in query result: ", N Rows( queryResult ) ) ) ); MyRunCompleteFunc = Function( {dt}, {Default Local}, Write( "Number of rows in query result: ", N Rows( dt ) ) ); query << Run Foreground( OnRunComplete( MyRunCompleteFunc ) );Next, if you try to delete the database, it will say that jmp ...
douglaschong

Discussions |
Oct 21, 2020 11:30 AM

2089 views | 1 replies
moving labels on GraphBuilder

I feel like this should be Graphbuilder 101, but I am stumped. So, I just want to make a couple of pie graphs and add the percentages as labels. But the labels are put in weird places, sometimes to where they can't be read. I thought you could actually manually drag text in some instances, but I failed there. I attached two scripts in the uploaded table ("test graphs"). Normally, you could just ad...
abmayfield

Discussions |
Oct 21, 2020 6:40 AM

3833 views | 3 replies
Subset data after filter

hello Everybody !I have a problem in my script.I have a big data table and i would like to subset some lines.I did a data filter and then subset or show subset, but i don't have "time" to select the filter in the window....how can i say in the script i have select first my filter and then subset the data tablei tried with a wait but it's not the best waythis is my script and i link my data basetha...
MargauxR

Discussions |
Oct 20, 2020 5:56 AM

1498 views | 1 replies
Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

1050 views | 0 replies

Previous
Next

Latest Discussions

Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

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

1284 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

905 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

1008 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

1322 views | 0 replies