JMP User Community

Latest Discussions

Sending OBDC Data Source connection with Add-in or Creating it through JSL

Hi all, I am trying to create an Add-in that pulls data from an SQL Server as data source, and I would need to distribute this Add-in to other users. The Add-in works perfectly, but the OBDC connection used by the Add-in is not being sent with it. Unfortunately, not everyone would be able/know how to create an OBDC connection to the SQL server in an easy way. Does anyone know how I could either ...
A_J

Discussions |
Sep 5, 2019 7:09 AM

3758 views | 3 replies
Getting a data table reference from NewSQLQuery() << Run Background with Names Default to Here(1);

I'm having trouble getting the data table reference if I run in the background. Anyone know how to get around this? names default to here(1); sql_query = New SQL Query( Connection( "ODBC:DSN=Test Source;DATABASE=Test;" ), QueryName( "Thingy" ), Select( blah ), From( other blah ) ); sql_query << Run Background( OnRunComplete( dt = queryResult; dt = data table(queryResult<<G...
vince_faller

Discussions |
Sep 4, 2019 6:01 AM

10670 views | 7 replies
Column Formula - Random from custom list of values

Hi,I have a list of values.I would like to create a column with formula that will return random value from that list.Is it possible? Thank you.
tom_abramov

Discussions |
Sep 4, 2019 5:00 AM

2917 views | 1 replies
1E+05 to 100000

Hi guys, Why the JSL didn't change the 1E+05 to 100000 when I tabulate the data? What can I do?
almighty22

Discussions |
Sep 3, 2019 11:31 PM

4257 views | 4 replies
Looking for script for new column formula for either geometric mean or 5% trimmed mean

My rows are products; my columns are ratings given by individual users. (The users saw most or all of the products). I would like to create a column of either geometric or 5% trimmed mean of rating for each of my product (I don't want the arithmetic mean which is the only option under Formula--> Statistical).
TCM

Discussions |
Sep 3, 2019 12:54 PM

7372 views | 7 replies

Previous
Next

Latest Discussions

1E+05 to 100000

Hi guys, Why the JSL didn't change the 1E+05 to 100000 when I tabulate the data? What can I do?
almighty22

Discussions |
Sep 3, 2019 11:31 PM

4257 views | 4 replies
In JSL, can I tell a modal window where to be?

For an ordinary window I can do this... nw = New Window( "test window", Text Box( "just trying out this window" ) ); nw << move window( 100, 500 ); But for a modal window that doesn't work - I get that, the window is busy waiting for inputs so doesn't get any message sent afterwards. I tried sending this message when creating the window. But if I do it after the <<modal message it does...
hardner

Discussions |
Sep 3, 2019 12:36 PM

9843 views | 7 replies
jmp cannot open a .jmp file

Please let me know if there are any known issues like this and/or any solutions or evaluations to help determine the issue and "fix" the file. There is a .jmp file I have been using since ≈2016. Last Thursday I worked on the file without issue (that I was aware of). This morning I could not open the file. The message I get is shown below along with the SW and some system info. The file is in a...
Elby

Discussions |
Sep 3, 2019 9:57 AM

3182 views | 1 replies
How to? Bland Altman Plot in Percentage (Matched Pairs)

Hello! How do i make the Matched Pairs graph to give results in percentage?

I also can see it doesn't have options for ratio, or log. I am just comparing one pair of data, and the differences assume a non-normal distribution and magnitude as an influence on the differences, and they are also proportional to variability, differences assume positive and negative values.

So i assume the proper way to m...
Sergio

Discussions |
Sep 2, 2019 4:04 PM

4001 views | 2 replies
Is there a way to remove the labels on the x-axis of a control chart for a point that was hidden? (Without deleting that row)

Is there a way to remove the labels on the x-axis of a control chart for a point that was hidden? (Without deleting that row)I have hidden/excluded certain rows but when I create control chart they still appear on the plot but with blank spaces where the points should be. I would like to excluded the sample label for the hidden values all together. Is this possible?
DIVIDESbyZER0

Discussions |
Sep 2, 2019 5:52 AM

9532 views | 5 replies

Previous
Next

Latest Discussions

How to Add Profit Matrix to Neural Net Confusion Matrix

Hi all, I'm using a neural net to predict whether or not a customer will prefer to buy retail items at a markdown or if they are likely to buy full-price (i.e., "bargain buyers" vs. traditional shoppers). I'd like to incoporate the opportunity cost of a false positive (giving discounts to what would otherwise be a full-price shopper) using a profit matrix, but changing values on the matrix in the ...
GhostBen

Discussions |
Aug 5, 2019 8:00 PM

1560 views | 0 replies
Capability Animation - How to see the LSL/USL Value?

I just discovered this nifty tool called the Capability Animation, where you can play around, dragging the spec limits and mean shifts, and it simulates your capability indices. But, I cannot see the actual LSL/USL values as I drag them! Does anyone know how to make this happen?
Antonio80

Discussions |
Jul 9, 2019 1:31 AM

1533 views | 0 replies
Unable to allocate enough memory in access or evaluation

Hi,I'm trying to use the Multivariate platform to perform a correlation between 6 time points (rows) across 73500 columns. My final goal is to output a 73500x73500 correlation matrix. When I try to run it, I immediately receive this pop out message:Unable to allocate enough memory in access or evaluation of 'List' , {/*###*/Estimation Method( 0 ), Matrix Format( 2 )} What's the issue? I'm using J...
ns

Discussions |
Jul 8, 2019 9:04 AM

1582 views | 0 replies
How to Post JSON data to a site via API functionality: "Unsupported Media Type"

Hi There, I am trying to perform a POST request to post some JSON data to a server, but unfortunately as of now I keep getting a 415 error. The goal of this script is to upload a JSON formatted file (or something of the like) to the server for other users to download/read. I noticed that there are very few POST examples with JSL, but quite the abundance with GET, which I have no problems with. I w...
liqinglei419

Discussions |
Jul 2, 2019 6:33 AM

1932 views | 0 replies
How to analyze crossover design data in JMP

I had crossover design data from one of my experiment, and I want to analyze it according to the rules of crossover design. Can someone please help me with this?
sharmachetan

Discussions |
Jun 14, 2019 2:34 PM

1478 views | 0 replies