JMP User Community

Latest Discussions

how to generate a data table through a graph which is a plot of some data?

if I only have a photo graph which is a plot of some data, but not have a its original raw data. can help to suggest how to generate a data set use this graph?My purpose is to generate a data set that can represent its profile, and join with others then can do a new plot to combine all togehter.can use jmp script or through its basic function tools? thanks a lot.
qspringleaf

Discussions |
Jun 7, 2021 1:01 AM

2903 views | 3 replies
Methods to add items (not in excel chart) into a table

Hello~ I use a JMP trial version. I want to add items (not in excel chart) into a table. Specifically, I want to make new columns just like excel. Somebody help me.. Thx:)
yummy

Discussions |
Jun 7, 2021 12:36 AM

1566 views | 2 replies
how to generate a data table through a graph which is a plot of some data?

if I only have a photo graph which is a plot of some data, but not have a its original raw data. can help to suggest how to generate a data set use this graph (>100 data points per each curve)?My purpose is to generate a data set that can represent its profile, and join with others then can do a new plot to combine all togehter.can use jmp script or through its basic function tools? thanks a lot. ...
qspringleaf

Discussions |
Jun 6, 2021 11:20 PM

1979 views | 3 replies
Replace multiple rows value from one column is not working properly

Hi JMP community, I have occured one issue that quite weird. Here's my code:dt_temp = data table("aaaa"); dt_temp << Summary( Group( :Column1,:Column2), Freq( "None" ), Weight( "None" ),output table name( "summary" ) ); data table("summary") << select where (:N rows >= 2 & !contains(:Column1,"AA") & !contains(:Column1,"BB") ); rows = dt_temp << get selected rows; dt_temp:Column3[rows] = ""; //C...
nthai

Discussions |
Jun 5, 2021 10:35 AM

3174 views | 7 replies
Wait until ODBC query is finished

New SQL Query() has several options for ODBC connections. Run several database queries (ODBC) in background and combine data afterwards, how to control running queries? << Run << Run Foreground (On Complete()) << Run Background ... Wait(0) Still is not clear to me what's the simplest way to wait until the query is finished and the table is ready,
FN

Discussions |
Jun 5, 2021 5:06 AM

1590 views | 1 replies

Previous
Next

Latest Discussions

Methods to add items (not in excel chart) into a table

Hello~ I use a JMP trial version. I want to add items (not in excel chart) into a table. Specifically, I want to make new columns just like excel. Somebody help me.. Thx:)
yummy

Discussions |
Jun 7, 2021 12:36 AM

1566 views | 2 replies
how to generate a data table through a graph which is a plot of some data?

if I only have a photo graph which is a plot of some data, but not have a its original raw data. can help to suggest how to generate a data set use this graph (>100 data points per each curve)?My purpose is to generate a data set that can represent its profile, and join with others then can do a new plot to combine all togehter.can use jmp script or through its basic function tools? thanks a lot. ...
qspringleaf

Discussions |
Jun 6, 2021 11:20 PM

1979 views | 3 replies
How to select and exclude rows from dt1 based on unique list of values from dt2?

so I'm using dt1 to run t-test analysis (Mean by Chamber by ChartID) then creating a combined data table, dt2, of all the pvalues. I want to filter this down to rows where p<=0.05, then create a distinct, unique list of these low pValues and use that to replot my chart with just the low PValues. I'm a bit stuck now trying to link back to the original dt1. The final select where doesn't seem to be ...
aliegner1

Discussions |
Jun 5, 2021 12:46 AM

2164 views | 5 replies
Medical Data cleaning in JMP from multiple excel sheets imported into JMP?

Hello,please kindly help me to find a more comfortable solution in JMP - rather what I do know, use excel incl VBA and import this into jmp:my medical database research is usually structured like, eg (master sheet):Unique identifierAgeWeightComorbidity 1 = Heart diseaseComorbidity2 = pulmonary diseaseAA3265yesnoAX3467yesyes an excel tab usually has ICD9/10 codes, eg:IdentifierICD CodeAAQ26.4AA776....
marc1

Discussions |
Jun 4, 2021 7:29 PM

1136 views | 1 replies
JSL to export Process Screening Detail Table

New JMP user here -- I would like to use JSL to save the output of a Process Screening analysis -- in particular, the Details Table. If I run the Process Screening analysis, a summary report pops up, and I've figured out how to save that. But from that report, I can click the red triangle and then "Save Details Table" to get much more granular information. I would like to save that table to a csv ...
eri

Discussions |
Jun 4, 2021 1:04 PM

1292 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

1283 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

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

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

Discussions |
Apr 20, 2021 1:41 AM

2286 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

973 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

1186 views | 0 replies