JMP User Community

Latest Discussions

Passing list as columns in a data table

Names Default To Here( 1 ); dt = Open( "$SAMPLE_DATA/Boston Housing.jmp" ); itemsY = {"chas"}; itemsX = {"crim", "indus", "nox", "rooms", "age", "distance", "radial"}; obj = dt << Predictor Screening( Y( itemsY ), X( itemsX ) );This code fails as list elements are not recognized as columns. How to solve this?
FN

Discussions |
Jun 19, 2021 2:10 AM

999 views | 1 replies
Putting labels in custom maps

I've built a custom map and it looks beautiful in Graphbuilder. What I would like to do is add labels to the regions in it but I just can't seem to figure out how that is done. An example would be from the online tutorial where the study is of temperature distributions in an office building. They describe how to make the custom map and the final result shows the actual room numbers on the map itse...
GregMcMahon

Discussions |
Jun 18, 2021 11:32 PM

1594 views | 1 replies
How to use column name as a variable.

I want to select some rows from a column ( I have a column named as 'RESOLUTION' in the current data table)This two lines will work:======================================dt = Current Data Table();dt<<Select Where(RESOLUTION > 0.);======================================If I define 'RESOLUTION' as another variable, it doesn't work:============================================dt = Current Data Table();...
qt

Discussions |
Jun 18, 2021 1:35 PM

5072 views | 5 replies
Get Rows() not working

I haverow_nums = data << Get Rows Where( num(data:"Donor") == i & data:"A or B" == "A"); d_A_rows = data << Get Rows(row_nums); Write(d_A_rows);but it writes the row numbers still instead of the actual row content. Am I missing something?
mostarr

Discussions |
Jun 18, 2021 11:43 AM

1616 views | 2 replies
Life Distribution - how to make the 2 plots in the same graph, one to show survival on, the other one not to show survival on?

I have an interval censored data table, when I do Life distribution --> compare groups, it gave me Plot1; what I really want is Plot2, in order to do that, I have to do life distribution without compare groups, generate plot3 with separate EVO/PVO plots, change the EVO to show survival curve, manually copy frame contents of PVO plot and paste frame contents into the EVO plot to get plot2. it is ve...
r30363

Discussions |
Jun 18, 2021 10:59 AM

1558 views | 1 replies

Previous
Next

Latest Discussions

Putting labels in custom maps

I've built a custom map and it looks beautiful in Graphbuilder. What I would like to do is add labels to the regions in it but I just can't seem to figure out how that is done. An example would be from the online tutorial where the study is of temperature distributions in an office building. They describe how to make the custom map and the final result shows the actual room numbers on the map itse...
GregMcMahon

Discussions |
Jun 18, 2021 11:32 PM

1594 views | 1 replies
How to use column name as a variable.

I want to select some rows from a column ( I have a column named as 'RESOLUTION' in the current data table)This two lines will work:======================================dt = Current Data Table();dt<<Select Where(RESOLUTION > 0.);======================================If I define 'RESOLUTION' as another variable, it doesn't work:============================================dt = Current Data Table();...
qt

Discussions |
Jun 18, 2021 1:35 PM

5072 views | 5 replies
Life Distribution - how to make the 2 plots in the same graph, one to show survival on, the other one not to show survival on?

I have an interval censored data table, when I do Life distribution --> compare groups, it gave me Plot1; what I really want is Plot2, in order to do that, I have to do life distribution without compare groups, generate plot3 with separate EVO/PVO plots, change the EVO to show survival curve, manually copy frame contents of PVO plot and paste frame contents into the EVO plot to get plot2. it is ve...
r30363

Discussions |
Jun 18, 2021 10:59 AM

1558 views | 1 replies
Refresh a JMP data table that had been previously populated with data imported from a .csv file

Hello JMP community, I need some help with refreshing of a JMP data table that was previously populated using the File -> Open -> Text File import option, in this case a .csv file. The first time, the data got imported with no issues, I then added a couple of column formulas at the end and done some graphs using the Graph Builder, which I saved the script to the data table and the file as normal. ...
VCO

Discussions |
Jun 18, 2021 6:24 AM

2553 views | 2 replies
time zone question

Hello, I have data in the UTC time format. Can someone tell me how to convert this data to my local time (Pacific Standard Time)? Thanks
domenowe

Discussions |
Jun 18, 2021 5:18 AM

1108 views | 1 replies

Previous
Next

Latest Discussions

ODBC Hive connection, change container size in the script?

Wondering if anyone can help here. I am trying to write some JMP scripts that SQL query data from a hive table. I need to change the container size and am told that I should just "do it in the connection settings". I was told that in python, you just add a configuration={"hive.tez.container.size":'10240'} parameter to the hive.connect call. How would I do this through JMP? I already have the Cloud...
aliegner1

Discussions |
Jun 17, 2021 3:43 PM

974 views | 0 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

1278 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

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

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

Discussions |
Apr 20, 2021 1:41 AM

2275 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

970 views | 0 replies