JMP User Community

Latest Discussions

Fast way to check for "wrong sensordata"

I have many different sensors (>>100) with many Data (continuous) each (>1mio) and update these each week.Sometimes these sensors "glitch" and send wrong data (below/above a low/high threshold)I want to calculate the number of "glitches" per week (KW=categorial) and need a fast way by JSL code.Example: negative data for this sensor should be detected (low threshold 0) My Solutions are too slow:
1.)...
MWalther

Discussions |
Apr 27, 2021 8:42 PM

2258 views | 5 replies
Increment a value for Run Number

I am trying to develop a formula that increments up the Run #. It should count up for each time a Shop Order has a new Process ID and reset back to 1 when a new Shop Order has not been run before. As shown below the Shop Order 532 has 3 different Process IDs, but they are not in order so it still increments up to 3 on the final one even though it isn’t in order. I created a column manually showing...
dkraeuter_sunne

Discussions |
Apr 27, 2021 8:36 PM

3844 views | 5 replies
Filter by row, stack columns?

I know how to make a subset table based on some criteria:dt << Row Selection( Select where( (:Stat == "mean"), Current Selection( Extend )) ); dt << Select Columns( [10, 20] ); dt2 << Subset( Output Table( "test"), Selected Rows( 1 ), Selected columns( 1 ) );But now I need to repeat the above for multiple criteria and stack the selection, i.e. the new table will have Column 10 as a fixed column, a...
student

Discussions |
Apr 27, 2021 4:03 PM

6054 views | 15 replies
Custom DOE Returning Rsquared of 1

Hello All, I am running a custom design DOE with 3 factors at 2 levels each but limited to only 10 runs. One of my factors is a hard to change variable. I have 4 responses in my DOE, 1 rated with importance of 1, 2 with importance of 2 and the remaining item with importance of 3. As you will see from the attached file, when the model script is run I get an RSquare value of 1 for "Delta in ROn Mean...
GSheehan1

Discussions |
Apr 27, 2021 3:49 PM

1082 views | 1 replies
JMP 14 column ordering difference

Any idea why an order of table columns is different to when others running same script? The content is the same the order is different.

For example I get column order TEST-9, TEST-12, TEST-17
But others would get TEST-12,TEST-17,TEST-9

The latter result is what I need to get is this a setting somewhere I need to change or a difference from JMP13 and JMP14?

Many thanks for any help given
AlexS

Discussions |
Apr 27, 2021 12:35 PM

3098 views | 6 replies

Previous
Next

Latest Discussions

Fast way to check for "wrong sensordata"

I have many different sensors (>>100) with many Data (continuous) each (>1mio) and update these each week.Sometimes these sensors "glitch" and send wrong data (below/above a low/high threshold)I want to calculate the number of "glitches" per week (KW=categorial) and need a fast way by JSL code.Example: negative data for this sensor should be detected (low threshold 0) My Solutions are too slow:
1.)...
MWalther

Discussions |
Apr 27, 2021 8:42 PM

2258 views | 5 replies
Custom DOE Returning Rsquared of 1

Hello All, I am running a custom design DOE with 3 factors at 2 levels each but limited to only 10 runs. One of my factors is a hard to change variable. I have 4 responses in my DOE, 1 rated with importance of 1, 2 with importance of 2 and the remaining item with importance of 3. As you will see from the attached file, when the model script is run I get an RSquare value of 1 for "Delta in ROn Mean...
GSheehan1

Discussions |
Apr 27, 2021 3:49 PM

1082 views | 1 replies
JSL Sum changing columns

Hello, if I have a table that changes once in a while something like this: but another day it can be something like this:and I want to somehow create a new row that will sum all the columns except for Date and Datawhat is the best way to do this in JSL?I tried taking the columns names and then removing data and date but then I'm not sure how to do the sum part for each columnI tried using summary ...
itzikd

Discussions |
Apr 27, 2021 12:04 PM

1676 views | 3 replies
How to code a split plot design in JMP Pro 15

Hello, I need advice on how to properly model a split-plot design in jmp pro 15. I think it needs to have random effects, so an LME model probably will work best I think? I have three main effects: Temperature(Categorical), Cultivar(Categorical), Cultivar*Temperature.Response Variable - (Continuous) Germination % The experiment was conducted on (1)thermal gradient table. The cultivars were randomi...
mcbeall08

Discussions |
Apr 27, 2021 8:36 AM

3429 views | 7 replies
Running Queries Menu bug?

Hi everyone, I think there is a problem with the "running queries menu" because I want to use this menu to prevent users of my queries from launching them several times queries when they run background.
So I thought I would use the jsl command:
Main Menu ("Running Queries");That works fine... once!Yes, because the problem is that once you close this window (manually or in jsl) it never reappears unt...
Franck_R

Discussions |
Apr 27, 2021 6:23 AM

4880 views | 10 replies

Previous
Next

Latest Discussions

多重比較での生存曲線の書き方　Bonferroniなど

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

Discussions |
Apr 20, 2021 1:41 AM

2493 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

1080 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

1350 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

1013 views | 0 replies
Workflow ideas for new projects

Hi all,

After a year of playing around with JMP, I'm extremely satisfied with using it as my main data exploration platform. However, I'm overwhelmed about the tremendous amount of ways I can begin to explore my data. When starting a new project, let's say a biomonitoring study for instance, where does one begin their workflow? Are there any literature on JMP for starting a project from beginning ...
MikeDereviankin

Discussions |
Mar 30, 2021 1:41 PM

1286 views | 0 replies