JMP User Community

Latest Discussions

Filemaker and SQL Query

Hello,Since the introduction of the SQL Query builder, I tried many times to use this tool without success. So I use the old way (open database) which force me to build manually the SQL queries. Now that we can mix external databases and JMP tables, I'd like to give a second chance to Query builder. It still doesn't work. The error message :The connexions with the Database works fine (I made an up...
claude_bellavan

Discussions |
Feb 26, 2021 11:19 AM

19390 views | 10 replies
Correct argument to limit open() to jmpaddin files

The JMP syntax reference says that open() can be limited to different file types. File Type An optional string that specifies the type of file that you are opening (for
example, "text", "journal", "sas", "script", "png", and "jmp"). This can be useful if your file
does not have a file extension, the file extension of the file does not match the contents of
the file, or you want to import a JSL BLOB....
johnmoore

Discussions |
Feb 26, 2021 9:14 AM

1369 views | 1 replies
Open microsoft office 365 cloud-based excel from JMP/JSL?

JMP recently got a built-in ability to open Google sheets. Before that in scripts I was calling an R package called Googlesheets to open them. Now my company is moving to office 365 so we'll have cloud-based shared excel sheets and I'm not sure how I'll be able to read from those. Is anyone opening these directly in JMP/JSL?
hardner

Discussions |
Feb 26, 2021 9:13 AM

15670 views | 11 replies
Select large number of rows

Hello,
I am looking for tips to help me select a large number of lines easily. Indeed, I work with large databases and when I want to select 15000 lines for example, I click on the first line and I scroll down to 15000. Then when I want to select the following 15000 lines I click on line 15001 and I scroll down to 30001 with my computer mouse
I tried with keyboard keys but it's also very long ...
Do ...
Emma1

Discussions |
Feb 26, 2021 5:09 AM

2403 views | 2 replies
statistical tests

I require help in finding statistical tests to run for my survey research. My responses consist of nominal and ordinal variables but I only get mosaic plots and nothing concerning t-tests or Mann-Whitney U tests. I am not sure what I am doing wrong. "9" represents missing data. Any help would be appreciated
tidifogo

Discussions |
Feb 25, 2021 7:49 PM

1181 views | 1 replies

Previous
Next

Latest Discussions

Correct argument to limit open() to jmpaddin files

The JMP syntax reference says that open() can be limited to different file types. File Type An optional string that specifies the type of file that you are opening (for
example, "text", "journal", "sas", "script", "png", and "jmp"). This can be useful if your file
does not have a file extension, the file extension of the file does not match the contents of
the file, or you want to import a JSL BLOB....
johnmoore

Discussions |
Feb 26, 2021 9:14 AM

1369 views | 1 replies
Select large number of rows

Hello,
I am looking for tips to help me select a large number of lines easily. Indeed, I work with large databases and when I want to select 15000 lines for example, I click on the first line and I scroll down to 15000. Then when I want to select the following 15000 lines I click on line 15001 and I scroll down to 30001 with my computer mouse
I tried with keyboard keys but it's also very long ...
Do ...
Emma1

Discussions |
Feb 26, 2021 5:09 AM

2403 views | 2 replies
statistical tests

I require help in finding statistical tests to run for my survey research. My responses consist of nominal and ordinal variables but I only get mosaic plots and nothing concerning t-tests or Mann-Whitney U tests. I am not sure what I am doing wrong. "9" represents missing data. Any help would be appreciated
tidifogo

Discussions |
Feb 25, 2021 7:49 PM

1181 views | 1 replies
Function in script to get log of a column

Hello,I was wondering how I would go about taking the log10 of a few of my columns and then having the data posted.E.g. For Column X, take the values (Y) and perform log10(Y) and save values under Column X Log
SI-2000

Discussions |
Feb 25, 2021 3:20 PM

3083 views | 4 replies
Turning a filterable dashboard into a "by" report/list

I have a fairly ugly request from a user that I am hoping has a simpler answer than what I am thinking. I have an exploratory analysis dashboard that generates around a few dozen graphs based on some choices in a filter. Mostly graph builder objects but also runs a process screening as well. What they would like is for the window of graphs to be repeated over and over again for each possible o...
Evan_Morris

Discussions |
Feb 25, 2021 1:55 PM

991 views | 1 replies

Previous
Next

Latest Discussions

What does it mean when the solution path for Elastic Net is not single-valued?

Dear JMP Community, (W10, 64-bit, JMP Pro 15.2.1) I am running a model to assess the active predictors. I am doing this by using the Autovalidation add-in to generate a Null Factor for my data. I then use the GenReg platform to find estimates for each possible X-factor and then Bootstrap those estimates to get a better assessment of the contributions to the response. I came across a very stran...
SDF1

Discussions |
Feb 15, 2021 12:35 PM

1443 views | 0 replies
Return number from specified row of calculation column in either a text edit box or number edit box in an add in

Hello, I'm attempting to build an application in application builder. I have two modules currently. The first module is a series of number edit boxes and lists that allow the user to input values and make selections.After pushing a button, the inputs and/or list selections update table variables in a data table that subsequently updates column equations. The data table opens in the background so ...
tys5384

Discussions |
Feb 15, 2021 7:33 AM

1285 views | 0 replies
generalized regression

How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.
Mrubra

Discussions |
Feb 3, 2021 2:31 PM

1090 views | 0 replies
Tablebox <

Using JMP 12.x, I noticed that: tablebox() <<sort by column does sort the column fine, but it does not seem to preserve any existing cell coloring post row sort. Is there any way to force it to preserve the existing cell colors post row sorting?
thanks, DJ
djhanson

Discussions |
Jan 14, 2021 9:17 AM

1397 views | 0 replies
Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

I'm using the neural platform to calculate a model that makes predictions from some observed data and want to compare the performance of that model to other models (not from JMP). To compare the different models, I want to compare the observed data and the predictions from the different models.The R2 is not a good measure because it checks for any linear relationship between the observed and predi...
matthias_bruchh

Discussions |
Jan 8, 2021 2:32 AM

3931 views | 0 replies