JMP User Community

Latest Discussions

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

3000 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

1609 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

2073 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

1291 views | 0 replies
JMP TIP: delete search / replace history

I frequently use the Search/Find/Replace (Edit > Search > Find) in data tables and scripts and even reports and journals, it is very useful. But one feature is that this tool retains the history of the terms you have used for search and/or replace. You will see them as a drop down in the dialog as shown below There are times, however, where you don't want to retain the search history and/or don...
MathStatChem

Discussions |
Jun 3, 2021 3:23 AM

1804 views | 1 replies

Previous
Next

Latest Discussions

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

3000 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

1609 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

1291 views | 0 replies
JMP TIP: delete search / replace history

I frequently use the Search/Find/Replace (Edit > Search > Find) in data tables and scripts and even reports and journals, it is very useful. But one feature is that this tool retains the history of the terms you have used for search and/or replace. You will see them as a drop down in the dialog as shown below There are times, however, where you don't want to retain the search history and/or don...
MathStatChem

Discussions |
Jun 3, 2021 3:23 AM

1804 views | 1 replies
Update from Database on a Timed Frequency

Hello,I currently have a script that requires user input to define variables that are used to query a database and generate control charts. To eliminate the need for an operator to provide these inputs again to generate the control charts whenever new data is in the database, I would like to automatically update the control chart on a timed frequency. For example: 1. User provides input.2. Initial...
Austin

Discussions |
Jun 2, 2021 9:23 AM

1079 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

1291 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

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

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

Discussions |
Apr 20, 2021 1:41 AM

2300 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

979 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

1194 views | 0 replies