JMP User Community

Latest Discussions

script after file import not executing

hi, I am importing bunch of files from a directory and stacked them into one big file(45 files), after import into one big file, the script will clean up the dataset, add columns and rows etc. the problem I encountered is that the script will error out if being executed together as a whole piece; if I run the import first, wait for the files to load into jmp, and then run the 2nd portion of the co...
r30363

Discussions |
Jun 3, 2021 2:56 PM

2280 views | 3 replies
Process Capability study doesnt display all parameters from Stdf file

i have a stdf file and when doing process capability study. for some reasons some parameters are missing. Any idea how to fix it?
steo45

Discussions |
Jun 3, 2021 2:48 PM

2605 views | 5 replies
How to create user inputs for SQL where filters?

So I'm using an ODBC to connect to SNOWFLAKE and run some scripts. Wondering how I can set up a UI window w/ a list of WHERE filters to make it easier for ppl to use. I'm envisioning a list with popups to then map to a variable to feed into the SQL script. possible? //**SNOWFLAKE QUERY**************************************************************************************************** uid = Get...
aliegner1

Discussions |
Jun 3, 2021 1:33 PM

3223 views | 2 replies
How do I Shorten the Fit line?

Hello,When I fit my data using the fit line tool it send the line till the end of the graph. I was wondering if there was any way to define how long the trend line should be, such that it only spans the region I want to show. Is there also a way to get the fit line to appear within the legend? Thanks!
SI-2000

Discussions |
Jun 3, 2021 9:44 AM

1820 views | 3 replies
Concatenate columns with empty cells

Hi all,I have a dataset with different columns that have some empty random cells (like the example in the table below). I would like to concatenate the values of the different columns and use the "_" to separate the content of the cells only if the content of the cells is different from empty value (as in column "concat" below). Does anyone have a suggestion on a how to to this operation in a smar...
JMP_fan

Discussions |
Jun 3, 2021 9:02 AM

2247 views | 3 replies

Previous
Next

Latest Discussions

script after file import not executing

hi, I am importing bunch of files from a directory and stacked them into one big file(45 files), after import into one big file, the script will clean up the dataset, add columns and rows etc. the problem I encountered is that the script will error out if being executed together as a whole piece; if I run the import first, wait for the files to load into jmp, and then run the 2nd portion of the co...
r30363

Discussions |
Jun 3, 2021 2:56 PM

2280 views | 3 replies
Process Capability study doesnt display all parameters from Stdf file

i have a stdf file and when doing process capability study. for some reasons some parameters are missing. Any idea how to fix it?
steo45

Discussions |
Jun 3, 2021 2:48 PM

2605 views | 5 replies
How to create user inputs for SQL where filters?

So I'm using an ODBC to connect to SNOWFLAKE and run some scripts. Wondering how I can set up a UI window w/ a list of WHERE filters to make it easier for ppl to use. I'm envisioning a list with popups to then map to a variable to feed into the SQL script. possible? //**SNOWFLAKE QUERY**************************************************************************************************** uid = Get...
aliegner1

Discussions |
Jun 3, 2021 1:33 PM

3223 views | 2 replies
How do I Shorten the Fit line?

Hello,When I fit my data using the fit line tool it send the line till the end of the graph. I was wondering if there was any way to define how long the trend line should be, such that it only spans the region I want to show. Is there also a way to get the fit line to appear within the legend? Thanks!
SI-2000

Discussions |
Jun 3, 2021 9:44 AM

1820 views | 3 replies
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

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

2430 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