JMP User Community

Latest Discussions

jmpaddin development on Github

I would like to migrate my add-in development to github and enable easy updating.If I push code, a github action should run that zips the source folder up and creates the latest.jmpaddin in the root of the repo.In the add-in I want to have a button that checks the latest.jmpaddin from the repo and downloads and installs if it is newer than the current version.Before I go deep into developing this:...
pauldeen

Discussions |
Aug 12, 2022 4:23 AM

2944 views | 7 replies
SQL Query custom expression - date range

I am trying to pre-filter a Query based on date range, but can't figure out how to get it to work. I keep getting this error. I have to be missing something simple, right?
Phil_Nash

Discussions |
Aug 12, 2022 2:36 AM

1804 views | 3 replies
JMP 16 Useable Year Week Column

I am trying to duplicate, in jmp, extracting the week from a date column that I pull in Excel with the following formula, =TEXT(A2,"YYYY")&"-"&TEXT(WEEKNUM(A2,2),"00"). The resulting week is in yyyy-ww format with a two digit week. When I add a new column and try concatenating Year & Week (Year( :Date ) || Week Of Year( :Date )) it doesn't allow me to concatenate the "-". If I forego the "-" it do...
WoHNY

Discussions |
Aug 12, 2022 1:02 AM

1491 views | 2 replies
Operation Rows

Hello everyone, I would like to know how to count the number of "OTPs" that are equal to 0 and make the division on the total number of LINES of OTP ? Thank you for your help
NetflixCrow956

Discussions |
Aug 12, 2022 12:52 AM

1331 views | 2 replies
How do I condition a for loop to work only for a particular set of rows

Hi,I'm trying to manipulate a data table with a formula, but I only want it to read for a few rows. Names Default To Here( 1 ); Open( "$SAMPLE_DATA/Cars.jmp" ); r = Current Data Table() << Get rows where( :Make == "Mazda"); For( i = r[1], i <= r, i++, :HeadIC[i] = :HeadIC[i]/2 ); Show(r);How do I make it so that it only iterates for those selected rows?
PowerOx327

Discussions |
Aug 12, 2022 12:45 AM

2295 views | 6 replies

Previous
Next

Latest Discussions

JMP 16 Useable Year Week Column

I am trying to duplicate, in jmp, extracting the week from a date column that I pull in Excel with the following formula, =TEXT(A2,"YYYY")&"-"&TEXT(WEEKNUM(A2,2),"00"). The resulting week is in yyyy-ww format with a two digit week. When I add a new column and try concatenating Year & Week (Year( :Date ) || Week Of Year( :Date )) it doesn't allow me to concatenate the "-". If I forego the "-" it do...
WoHNY

Discussions |
Aug 12, 2022 1:02 AM

1491 views | 2 replies
Spec Yield Analysis

Dear JMP Community, I am new to JMP and wanted to build a widget which would allow sliding spec limits and resulting yield assessments for a product. Such a capability can be super helpful for me. Perhaps also for other engineers working with cost sensitive products may also benefit from the discussion. I have included a table describing the problem statement. Description of ask (table above): As...
DataCom

Discussions |
Aug 11, 2022 9:30 AM

1512 views | 2 replies
How to encode JSL to decrypt AES encrypted text with a known Key and IV?

Hello!Does JSL have modules for text encryption and decryption?Thanks! AHKString(AlgId, Mode := "", String := "", Key := "", IV := "", Encoding := "utf-8", Output := "BASE64")
lala

Discussions |
Aug 11, 2022 7:07 AM

1080 views | 1 replies
JMP Query Builder not showing tables which are visible in Database/Open Table

Hi Folks, I'm troubleshooting an issue with some JMP queries and I've discovered I can see and access the required Oracle tables within a schema when I open the tables using the Database/Open Table option. These same tables are not visible when I use the Build Query option using the same ODBC driver and user account.I am using JMP 15 Pro.Is there something (probably very simple) I am missing here...
BrendanM

Discussions |
Aug 11, 2022 12:50 AM

2838 views | 4 replies
How to preserve or recreate Combined Prediction Profiler color shading?

If I run the Fit Modelplatform, the "Combined Prediction Profiler" in the resulting Fit Group has pink shadings that indicate the factor's importance. Now I save the Fit Group, either using Save As, or using Save Script>To data table. If I close, then re-open the files, and either open the saved Fit Group or re-run the saved script, the Prediction Profiler has now lost the shading. Why? It's ver...
TheDude

Discussions |
Aug 9, 2022 7:00 PM

1792 views | 3 replies

Previous
Next

Latest Discussions

JSL Script Creates New Taskbar Icon When Run

Hi All, I have what seems to be an odd problem. I've created a JSL script that launches a window through which a user can select some options and then run scripts to pull data from various sources. The odd thing that is happening is that when one of these scripts is run it causes all subsequent JMP windows to open under a new taskbar icon. An example for clarity: 1) User opens jmp. There is 1 icon...
jbakri

Discussions |
Aug 1, 2022 12:32 PM

1137 views | 0 replies
Choice model platform and marginal effects?

Hi everyone,I have used the choice model platform to design and analyse choice experiments. However, at the analysis step, there are some parts of JMP platform output that are not clear, and I wonder if you can provide an answer:It is not clear how marginal effects are calculated in JMP.More specifically, how do we obtain marginal probabilities from marginal utilities since neither the utility fun...
gav2013

Discussions |
Jul 18, 2022 7:14 AM

1053 views | 0 replies
July/August classes from JMP Education

JMP Education is offering upcoming classes with a live instructor. Links go to the page in the course catalog with more information and a link to register. July 26-29: JMP: Reliability Analysis for Non-Repairable Systems August 9-12: JMP Pro: Analyzing Curves and Profiles Using the Functional Data Explorer August 16-19: JMP: Statistical Decisions Using ANOVA and Regression August 29-September 1: J...
Di_Michelson

Discussions |
Jul 11, 2022 8:50 AM

693 views | 0 replies
Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...
MomentMonster90

Discussions |
Jun 13, 2022 5:53 AM

816 views | 0 replies
Validate column values (make sure all values in column follow a specific pattern)

Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?
miguello

Discussions |
May 6, 2022 11:09 AM

651 views | 0 replies