JMP User Community

Latest Discussions

Add-in: Log Error

I read through post:discussion1 but still I could not resolve my error.The full script is large so I just condensed it down to a few lines.When I create the add-in, the Log says: Name Unresolved: DSN in access or evaluation of 'DSN' , DSN/*###*/ Clear Log(); ::DSN = "a64"; ::connection = eval insert("DSN="||"^DSN^"||";UID=stuff;PWD=place;"); ct = Open("C:\Users\tom_p\Deskto...
Tom_P

Discussions |
Oct 13, 2021 6:21 AM

1265 views | 2 replies
tabular report alternative

As we know Tabular report doesnt support color cells.Therefore when its in a report there is no clear visualisation.What is an alternative for this and how do we add the data table with color to the Window.can I append the dt into a v list box so it can be but into my tab box report?
jearls11

Discussions |
Oct 13, 2021 2:44 AM

1182 views | 2 replies
如何用脚本计算出最符合的值？

大家好!如图: 有若干组数据、它们的数据比较接近。每组数据有大、小两个值。如何通过脚本来求出图中红色的水平线的最优值:要求这个水平线与能这组数据最多的其中一个端点接近、要求这条线是水平的。我试着用最小二乘法来回归、但还是不理想。谢谢各位专家!
lala

Discussions |
Oct 13, 2021 12:36 AM

2363 views | 4 replies
Building a custom date format to include milliseconds: 2020-06-11T03:18:30.000Z

I have used the custom date format generator to produce this custom format (which does not work):<YYYY><-><MM><-><DD><'T'><hh24><:><mm><:><ss><:><ss> The format I received from Twitter has th period between seconds and hundredths, but that is not an option in the date format builder.
LNitz

Discussions |
Oct 13, 2021 12:14 AM

1076 views | 1 replies
Can’t set the tick mark line weight

[Moved from Graph Builder: allow setting the tick mark line weight] This doesn't seem to work for me. I can change the axis line weight but not the tick mark weight by modifying line width in properties. Weirdly, I can only increase it once, the line weight won't update after the first change. Likewise, I'm trying to solve a similar problem, which is tick mark weight and length. You see, my ne...
buzuddha1

Discussions |
Oct 12, 2021 12:02 PM

2409 views | 4 replies

Previous
Next

Latest Discussions

Building a custom date format to include milliseconds: 2020-06-11T03:18:30.000Z

I have used the custom date format generator to produce this custom format (which does not work):<YYYY><-><MM><-><DD><'T'><hh24><:><mm><:><ss><:><ss> The format I received from Twitter has th period between seconds and hundredths, but that is not an option in the date format builder.
LNitz

Discussions |
Oct 13, 2021 12:14 AM

1076 views | 1 replies
Can’t set the tick mark line weight

[Moved from Graph Builder: allow setting the tick mark line weight] This doesn't seem to work for me. I can change the axis line weight but not the tick mark weight by modifying line width in properties. Weirdly, I can only increase it once, the line weight won't update after the first change. Likewise, I'm trying to solve a similar problem, which is tick mark weight and length. You see, my ne...
buzuddha1

Discussions |
Oct 12, 2021 12:02 PM

2409 views | 4 replies
Extract factor range from bivariate graph

How do I efficiently extract the crossing points of this curve and its 95% CI with an arbitrary Y value.dt = Open( "$sample_data/Growth.jmp" ); biv = Bivariate( Y( :age ), X( :ratio ), Fit Line( {Line Color( {204, 121, 41} )}, save studentized residuals ), SendToReport( Dispatch( {}, "Bivar Plot", FrameBox, {Grid Line Order( 3 ), Reference Line Order( 4 )} ) ) ); biv << (Curve...
pauldeen

Discussions |
Oct 12, 2021 11:45 AM

4732 views | 14 replies
Combine columns which contain specific substring in their name

Hi, I am trying to combine only the columns in Data table "dtPatList" which contain the substring "INIT" in their name, but it doesn't work.I understand that the problem related to the parameter I bolded below. could someone advise for the right way? Thanks!! // get the dt cols namesnc = ncols(dtPatList); // get the dt cols namescol_list = dtPatList << get column names(string);for (i = nitems(col...
AdirZig

Discussions |
Oct 12, 2021 9:39 AM

1016 views | 2 replies
Error "send expects scriptable object..."

HI Everyone, I'm trying a very simple script that is meant to function within a data table, in other words, I have the data table allready and have created a script within it (not sure is that's relevant but thought I'd specify...).
I'm trying to retrieve the spec limits from column7 below and getting this error everytime:

"Send expects scriptable object in access or evaluation of 'Send', Eval Exp(...
Tachyon34

Discussions |
Oct 12, 2021 9:25 AM

1245 views | 1 replies

Previous
Next

Latest Discussions

non-parametric response screening

I love the response screening platform. Is there a way to choose the fit y-by-x model to be non parametric, so i can compare non-normal distributions? is that the Huber/cauchy options?thanks
ezorlo

Discussions |
Oct 11, 2021 1:03 AM

611 views | 0 replies
JSL: Saving multiple chart and auto fit each of them into 1 page

I have created a Window with V List Box which contained multiple Variability Charts and tried to save them into 1 pdf. What i want to achieve is saving and auto scale each of the Variability Charts into 1 single page of pdf. Can anyone help to advise how to do that? Much appreciated!nw = New Window( "taskQueryCharzCurrent - Variability Chart of current", V List Box( Variability Chart( Y( :cu...
giin

Discussions |
Oct 7, 2021 6:42 AM

800 views | 0 replies
Skip Lot Sampling Plan

Hi,I am interested to use JMP for skip lot sampling plan. I like to test only a fraction (f) of samples after successful inspection of (n) number of samples. Here is the link to NIST https://www.itl.nist.gov/div898/handbook/pmc/section2/pmc27.htm I appreciate any help you can provide. Thanks Adam
AT

Discussions |
Sep 10, 2021 10:38 AM

948 views | 0 replies
Time values in xls or xlsx, csv, and JMP

Hi all, I have a strange issue with the time values from my excel. I have some data (example is attached here as excel file), the time column is an interest for me and I would add the date and time column together to create a date time column. To analyze the data, I use JMP so I am importing the excel file.However, I ran into a number of oddities:1. When I import multiple files (from customers to ...
fliew0410

Discussions |
Sep 7, 2021 7:25 AM

946 views | 0 replies
Error while using Azure MFA to connect with JMP

I have rightly set up the ODBC connection version 17 for SQL server using Azure MFA. However, when I try to connect for the DSN via JMP i get the following error. how to overcome this error in JMP14. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Password option must not be specified, if Authentication option is 'ActiveDirectoryInteractive'.
hariharan249

Discussions |
Sep 3, 2021 7:14 AM

660 views | 0 replies