JMP User Community

Latest Discussions

Help with If Statement

I'm currently trying to write a script that reads a column from my data table, and runs a different set of functions depending on the value of that column. For example, If the data in Column A = A, create a new column called "A" and run the functions (A to C) below. If the data in Column A = B, create a new column called "B" and run the functions (D to F) below instead. Else, create a new column...
cheeseistasty

Discussions |
May 29, 2021 8:46 AM

2577 views | 3 replies
output data table query from database is all categorical (numerical columns changed to categorical)

Hi,I 'm using the query builder to get data from database. The the included columns from table are a mixed of categorical and numerical type. After I clicked Run Query, a table appears and contains all the columns I needed. However , all the columns appear in categorical type. How I can make sure not losing the data type when query data using jmp?
dadawasozo

Discussions |
May 29, 2021 8:15 AM

3258 views | 6 replies
MSA - getting repeatable

I am a new user off JMP. Something is fishy. I am getting a zero EV value on every MSA calculation. First I started with a destructive MSA, here I thought oh well maybe it has something to do that I cannot repeat the measurement on the same part. But here is a simple resistivity measuring MSA , crossed, so there for sure should be an EV value stated. What am I doing wrong, must be some simple sett...
Achim

Discussions |
May 29, 2021 5:26 AM

1689 views | 4 replies
How to remove a set of values from a matrix/vector?

Hi. I have a large vector (i.e. 1-D matrix) of values, from which I'd like to remove a subset of the values, where the subset contains a non-sequential set of values from the original vector. For example: largevect = [1,2,3,4,5]subset = [2,5]desired result = [1,3,4] I'm wondering if a simple command or set of commands exists that could do this in JSL? I could do this with a For Loop, but wonder...
nikles

Discussions |
May 28, 2021 1:27 PM

5595 views | 6 replies
Creating variable Y axis to plot/overlay parameters

Hello Folks,I am trying to overlay create a variable y axis to plot multiple parameters using my columns. my time being the x axis.Example if click on A and B they should overlay. Or if I click A and C etc.Can I create a data filter of columns as my y axis and when i click on them they will populate the graph?I am currently using a different software to do this and you have to change names . but y...
jearls11

Discussions |
May 28, 2021 1:19 PM

2138 views | 3 replies

Previous
Next

Latest Discussions

Help with If Statement

I'm currently trying to write a script that reads a column from my data table, and runs a different set of functions depending on the value of that column. For example, If the data in Column A = A, create a new column called "A" and run the functions (A to C) below. If the data in Column A = B, create a new column called "B" and run the functions (D to F) below instead. Else, create a new column...
cheeseistasty

Discussions |
May 29, 2021 8:46 AM

2577 views | 3 replies
output data table query from database is all categorical (numerical columns changed to categorical)

Hi,I 'm using the query builder to get data from database. The the included columns from table are a mixed of categorical and numerical type. After I clicked Run Query, a table appears and contains all the columns I needed. However , all the columns appear in categorical type. How I can make sure not losing the data type when query data using jmp?
dadawasozo

Discussions |
May 29, 2021 8:15 AM

3258 views | 6 replies
MSA - getting repeatable

I am a new user off JMP. Something is fishy. I am getting a zero EV value on every MSA calculation. First I started with a destructive MSA, here I thought oh well maybe it has something to do that I cannot repeat the measurement on the same part. But here is a simple resistivity measuring MSA , crossed, so there for sure should be an EV value stated. What am I doing wrong, must be some simple sett...
Achim

Discussions |
May 29, 2021 5:26 AM

1689 views | 4 replies
Variance components analysis - manufacturing process

Hi all,I’m looking to understand the variability associated with a multi-step manufacturing process. I think the way to do this is to plot the plot using the variability /attribute gauge chart, then use the variability components analysis. But, I’m unsure of what variability model (crossed, nested, etc) to use. With that said, let me give some more detail. Our raw material input (let’s call the...
barnabei

Discussions |
May 28, 2021 9:51 AM

2573 views | 5 replies
How to freeze ColBox of TableBox via JSL while scroll X-Axis of TableBox?

I want to freeze below columns "PROGRAM_NAME_NO" and "IBType" while scrolling X-Axis of TableBox?Is there anyone who knows how to solve this issue? Do appreciate your favor.
baiyun

Discussions |
May 28, 2021 6:28 AM

2698 views | 6 replies

Previous
Next

Latest Discussions

Can I control text size in a word cloud inside a dashboard container?

Hi all,I have a dashboard with a data filter, a map, and a word cloud that looks like image 1 below. I have two formatting issues with the word cloud I'd like to fix. First, by design, when I make different selections using the data filter, the subset of records that are shown in the map changes and the word cloud applies only to that selection. However, when I change the data filter selection, th...
caseylott

Discussions |
Apr 28, 2021 12:03 PM

1263 views | 0 replies
多重比較での生存曲線の書き方　Bonferroniなど

4群での生存曲線をJMPproでの書き方を教えて下さい。また、JMPで「環境設定グループ」から「レポート」を選択し、「ローカルデータフィルター」を出せればできる方法も紹介されていたのですが、「ローカルデータフィルター」を出せません。どの方法でもよいので、JMPProで、多重比較法を用いた生存曲線の書き方をどなたか教えてください！宜しくお願い致します。
27070

Discussions |
Apr 20, 2021 1:41 AM

2266 views | 0 replies
Fantasy Baseball League

I am in a 16 team fantasy baseball league. Each week we tabulate totals for home runs, batting average, stolen bases, wins, saves, era, etc. If my team has the most home runs, I win that category for the week. We track 10 statistics so after each week I may have a final score of 6-3-1. My question is how can I use JMP to check what my score would have been if I had played each of the other 14 team...
atlas100

Discussions |
Apr 19, 2021 1:29 PM

963 views | 0 replies
Generation of overdispersed poisson count data (vs gamma poisson)

Hello, I would like to reconcile the parametrization used in the Random Gamma Poisson(lambda, sigma)with the over-dispersion parameter as estimated in generalized linear model platform. Take for instance the attached table. Here the generating function is Random Gamma Poisson(exp(1+3*:X1),10)Running glm with poisson/log + overdispersion I obtain: Overdispersion = 6.09. Is there any way to link...
matteo_patelmo

Discussions |
Apr 12, 2021 9:53 AM

1171 views | 0 replies
JSL Syntax Change is coming: Name() is being deprecated

Hi All, I just read here that the JSL syntax for referencing a column using the Name() parser is going away. The new syntax is currently in use and at some point the old syntax will be removed entirely. There's a lot of people here who script, so thought it would be good to post something here. I know I have a lot of code I'll need to change! Better to be ahead of the curve and change it befor...
SDF1

Discussions |
Apr 7, 2021 10:14 AM

882 views | 0 replies