JMP User Community

Latest Discussions

How does one copy the same data down across several rows?

You know how one can drag or double click to copy a cell down to the end in Excel. Is there an easy way to do that in JMP? Or is the best way just to type up my data in Excel which is much easier/faster for me?
Lcheng

Discussions |
Jun 14, 2021 9:35 AM

3388 views | 2 replies
How to remove/hide the sigma message at the bottom of a control chart?

Hello all I have a formatting issue where at the bottom of a Control Chart i have a message with "Note Sigma was specified during launch" in the bottom left hand corner. If I right click I can select to hide it. Unfortunately i have many charts with the same message. My question isIs this available through preferences to not display this message? If no, is there any other alternative? thank you
AlexS

Discussions |
Jun 14, 2021 8:17 AM

2767 views | 5 replies
Graph Builder > Spaghetti Plot With Average: How to create without Customization?

Hi JMP Community, I'm trying to produce a large number of "spaghetti plots" with average lines for 3 categories as shown below but the only way I was able to build this example is by using a Custom Graphics Script: Is there a way to produce this graph more efficiently by for example combining more than 1 overlay criteria? Also, what is the proper syntax to assign specific color to the Markers adde...
Thierry_S

Discussions |
Jun 14, 2021 7:17 AM

2869 views | 2 replies
How to prompt user to name SQL query output data table and add date and time to filename?

Dear all,I am asking for your expert advice on the following topic, since I am really new to JMP scripting. I made a SQL query (invisible) through the Query builder but I need help to: - prompt the user to insert data table file name (pop-up window);- add date and time (ddmonyyyy:h:m:s) to the output data table What I managed to script is here below:Names Default To Here( 1 ); dt=New SQL Query( V...
FabioSaragoni

Discussions |
Jun 14, 2021 4:59 AM

2522 views | 4 replies
Looking for a way to have a single local data filter control multiple graph in a report

Hello, I've built a report with multiple graphs. The graphs are showing different aspects of the same data. I'm looking for a way to script so that I can specify a single local data filter to control multiple graphs in the report. I could use the data filter instead but I see 2 issues with that approach:1- In JMP16, it seems that that data filter cannot be included in a report along with some gra...
Sburel

Discussions |
Jun 13, 2021 7:32 PM

1030 views | 1 replies

Previous
Next

Latest Discussions

Looking for a way to have a single local data filter control multiple graph in a report

Hello, I've built a report with multiple graphs. The graphs are showing different aspects of the same data. I'm looking for a way to script so that I can specify a single local data filter to control multiple graphs in the report. I could use the data filter instead but I see 2 issues with that approach:1- In JMP16, it seems that that data filter cannot be included in a report along with some gra...
Sburel

Discussions |
Jun 13, 2021 7:32 PM

1030 views | 1 replies
Dynamic Calculator Add in to Calculate Statistics As i Select and Unselect Rows

Hi All, Am looking for a add-in to JMP to calculate the basic statistics (quantiles, means, medians, stdevs, ranges) of my tables automatically based on the rows/columns I am picking and changing in a different window, charts are a bonus, but just come comparison tables would be great now; Rather then plotting graphs over and over. Any recommendations? Thank you!
Italianbaby757

Discussions |
Jun 12, 2021 11:53 PM

2103 views | 3 replies
Fit Model - Effect Summary - no PValues?

Question: Why are there no LogWorth and PValues showing up in my Effect Summary section after I Fit Model an output with several inputs & second degree inputs (Factorial to Degree 2)? Context: Everything is continuous except 1 nominal dataset. I first did 6 singular outputs. it gave me some results so I could use that to eliminate the 2 at the end. But then I tried adding 2nd order inputs and: Am...
Lcheng

Discussions |
Jun 12, 2021 6:13 AM

1351 views | 1 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

2283 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

1178 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

1273 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

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

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

Discussions |
Apr 20, 2021 1:41 AM

2269 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

1173 views | 0 replies