JMP User Community

Latest Discussions

How to pass a date to an SQL Query in JMP

I’m getting a data sheet via SQL into JMP. One column is a :Date column. I’d like to pick the last date (Max value) or "last date-1 day" from this :Date column and transfer this date into an update querry, where CustomSQL( “ … Date >= ...) is.
Thomas1

Discussions |
Aug 20, 2019 8:22 AM

2802 views | 1 replies
How do I prevent JMP Alerts from popping up?

When I use a combo button on the dashboard I get a JMP Alert. Nevermind what the alert says because it runs smoothly besides the popup. Is there a way to prevent or close that Alert within the script? I have tried: Combo11 << Batch Interactive ( 1 ); throw(); stop(); Thanks for the help!
Kelly

Discussions |
Aug 20, 2019 7:30 AM

2153 views | 1 replies
How to use select where to pick up particular range of value?

almighty22

Discussions |
Aug 20, 2019 7:23 AM

6173 views | 9 replies
Help to develop script for normalized calcualtion

Hello, Could I get some help to develop a script which can calculate a normalized score. For example, in the attached sheet I have point scores for 5 people. It is difficult to compare them as is since each person's score seem to be on a different scale.I would therefore normalize the data and compare. First, I compute the average score for each person and then divide each person's score with his ...
raj138

Discussions |
Aug 19, 2019 2:30 PM

3280 views | 4 replies
copy column from one table to another (bring the formula and the heading

Hi. I have two tables. one with the heading and formula I need.And at other tables is the one with the formulas. How can copy the column from one table (bring the formula and the heading) to another. Thanks
Batista

Discussions |
Aug 19, 2019 9:19 AM

2649 views | 3 replies

Previous
Next

Latest Discussions

How to use select where to pick up particular range of value?

almighty22

Discussions |
Aug 20, 2019 7:23 AM

6173 views | 9 replies
copy column from one table to another (bring the formula and the heading

Hi. I have two tables. one with the heading and formula I need.And at other tables is the one with the formulas. How can copy the column from one table (bring the formula and the heading) to another. Thanks
Batista

Discussions |
Aug 19, 2019 9:19 AM

2649 views | 3 replies
Interactively changing menu in an add-in

I have developed a handful of add-ins that are similar but slightly different. Each contains 30-40 scripts. Most of the scripts are the same,but some of the scripts available are different. The differences are based on geography. I would like to combine these into one add-in with the ability to select geography. For example, if the user selected "Europe" as geography, the menu would change to ...
johnmoore

Discussions |
Aug 16, 2019 12:16 PM

1423 views | 1 replies
Graphbuilder: Side by side bars

Hi,
I have a graph with two Y-axis with different scales.
The bar style is "Side by side" but they seem to cluster together.I tried to put fewer samples on the graph so there would be fewer bars but that didn´t work.Any ideas of how to make them side by side and not cluttered together?Best regards
helmon

Discussions |
Aug 16, 2019 12:10 PM

3947 views | 3 replies
Convert character timestamp to typical numeric format

I would like to convert a character timestamp format like this one:06/28/19 11:26:29:252to a typical numeric format06/28/19 11:26:29Any help much appreciated.
WHG

Discussions |
Aug 16, 2019 6:42 AM

4883 views | 7 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

1374 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

1314 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

1436 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

1667 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

1285 views | 0 replies