JMP User Community

Latest Discussions

How can calculate the geometric mean of some rows?

The geometric mean can be easily obtained in Summary.
But how to calculate the mean by the formula column, right?
I searched the help documentation and the community and still couldn't find a way.
I want to calculate it this way:dt=Current Data Table(); dt<<New Column("text",formula(Geometric Mean(:height[Index(Row()-10,Row())]))); dt<<run formulas; Thanks!
lwx228

Discussions |
Jun 11, 2021 5:22 PM

6845 views | 7 replies
How to match and fill column/rows based on results

Hi, I was wondering if this is possible do to write a script for an analysis similar to the one below? In one column ("Month"), I have all 12 months of the year (January to December), with each month having multiple rows in the same column. In the next column ("Condition"), there is a condition for that month, either "A" or "B". In a 3rd column ("Result"), I want to write a formula that analyzes t...
cheeseistasty

Discussions |
Jun 11, 2021 1:22 PM

2543 views | 3 replies
JMP Script filter multiple parameters from multiple columns

See for example, I have data table below, with column name A, B, C, and I want to:Filter Column "A" by exclude "a" and "c" & Filter Column "B" by exclude "e" and "f" & Filter Column "C" by exclude "g" and "h"In the end, I want to delete rows that being excluded above based on the 3 criteria from each column. How can I script to make this happen? ABCadgbehcfiaeibfhcdgaeibdgcfh
aaronjiang

Discussions |
Jun 11, 2021 12:23 PM

1336 views | 1 replies
Setting Spec Limits using Column Data

Hi,I have a query that produces a data table with parameter test results and spec limits listed in different columns (example below). Is there a script that can set the spec limits to each parameter? Would I need to rearrange my data table for this to work? Sample IDParameterLSLUSLResultSample 1Parameter 15106Sample 2Parameter 15107Sample 3Parameter 2143Sample 4Parameter 2142Sample 5Parameter 3102...
Austin

Discussions |
Jun 11, 2021 8:41 AM

2551 views | 3 replies
Conditional value labels for missing values

I wonder if there's a way to set up conditional value labels based on values from two columns. If I refer to the snapshot table below, I have "column 1" which could either be filled or empty and I also have "column 2" which either be filled or empty. What I'm trying to do is for "column 2" to be formatted like "Column 3". Which is: (i) values formatted to a date format if there's a value AND the "...
Djtjhin

Discussions |
Jun 11, 2021 8:38 AM

2597 views | 5 replies

Previous
Next

Latest Discussions

How to match and fill column/rows based on results

Hi, I was wondering if this is possible do to write a script for an analysis similar to the one below? In one column ("Month"), I have all 12 months of the year (January to December), with each month having multiple rows in the same column. In the next column ("Condition"), there is a condition for that month, either "A" or "B". In a 3rd column ("Result"), I want to write a formula that analyzes t...
cheeseistasty

Discussions |
Jun 11, 2021 1:22 PM

2543 views | 3 replies
JMP Script filter multiple parameters from multiple columns

See for example, I have data table below, with column name A, B, C, and I want to:Filter Column "A" by exclude "a" and "c" & Filter Column "B" by exclude "e" and "f" & Filter Column "C" by exclude "g" and "h"In the end, I want to delete rows that being excluded above based on the 3 criteria from each column. How can I script to make this happen? ABCadgbehcfiaeibfhcdgaeibdgcfh
aaronjiang

Discussions |
Jun 11, 2021 12:23 PM

1336 views | 1 replies
Conditional value labels for missing values

I wonder if there's a way to set up conditional value labels based on values from two columns. If I refer to the snapshot table below, I have "column 1" which could either be filled or empty and I also have "column 2" which either be filled or empty. What I'm trying to do is for "column 2" to be formatted like "Column 3". Which is: (i) values formatted to a date format if there's a value AND the "...
Djtjhin

Discussions |
Jun 11, 2021 8:38 AM

2597 views | 5 replies
Simple method to copy multiple column properties to a new data table?

I need to copy the column properties for 82 columns to a new data table which has the same number of columns and same column names. I seem to remember in the past that there was a quick and simple method, using a few mouse clicks and GUI interface (non-scripting method) to do this. I don't see these options anymore in any of the menus or sub-menus. Am I making this up, did this capability never...
notoriousapp

Discussions |
Jun 11, 2021 8:29 AM

17629 views | 10 replies
Name Unresolved. Works when I re-do script but not in original script??

So I have a script that is creating YbyX plots, doing a Tukey T-Test, then creating a combined dt with the p-Values, then selecting and excluding based on the p-Value. I currently have it embedded inside a dt << New Script() function to save it to the source data table. I'm not sure what is going on but when I get to the section to select the p-Values, I get this error:dt1 << select where("p-Value...
aliegner1

Discussions |
Jun 10, 2021 2:50 PM

2125 views | 1 replies

Previous
Next

Latest Discussions

Using a List to Filter in Custom Query Builder - Question

Hello, I would like to use a list to filter within a continuous column in Query Builder. Range and then join does not work as my data set from my database will be tens of millions of lines, so I would like my list to be the only thing queried. I would like to use a list (I have a separate data sheet with the column) of about 40 or so unique numerical values and use that in the filter for a custom ...
Benjamin_S

Discussions |
Jun 3, 2021 7:59 AM

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

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

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

Discussions |
Apr 20, 2021 1:41 AM

2429 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

1052 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

1298 views | 0 replies