JMP User Community

Latest Discussions

Pareto Analysis - generate table

What is the fastest/easiest way to generate a table with he information that I get via % of total in Graph Builder? Unfortunately, % of total in Summary and Tabulate take all rows of the table as a references.But I need a separate analysis for each group - like in Graph Builder or in Pareto. Per Unit Rates in Pareto gives the correct list - but unfortunately, it's into 2 DisplayBoxes. As this is a...
hogi

Discussions |
Oct 19, 2023 11:29 AM

989 views | 3 replies
Run radiobox using jsl

Hi, Is there a way to run the radiobox using set?Tried the following code but doesn't workNames Default To Here( 1 ); New Window( "Example", r1 = Radio Box( {"Red", "Green", "Blue"}, das = r1 << get selected; if(r1 == "Green", Caption("Green")) ) ); r1 << set( 2, runscript(1) );
Jackie_

Discussions |
Oct 19, 2023 11:14 AM

646 views | 1 replies
Color code Top 5

I would like to color code my table (so that all the charts and graphs I make follow the same). But I want to do it so that top 5 are red, middle 15 are yellow, and bottom 27 are green. There has to be an easy way to do this. For context, I have all the CDC rate data for various diseases that I need to track for 2014-2021. I need to be able to compare the US to any of the states and have it show ...
patriciafm811

Discussions |
Oct 19, 2023 9:44 AM

3312 views | 10 replies
Automate importing files

I have imported an excel file using workflow and am editing the script to be more general. Within the import settings under Column names starts is a specific number but instead I want it to be when a specific condition is met (e.g. when row 5 column 2 says START with start being the column name). Any help in the right direction is very appreciated. The snippet of code is below with the importan...
MedianRooster10

Discussions |
Oct 19, 2023 9:36 AM

756 views | 2 replies
Open Multiple files in different folders

I have experimental results in 2 different formats as excel files under different folders depending on the conditions of the experiment. Is there a way for the user to state the parent directory and then JMP will open all the excel files as data tables?I also need need to be able to state the row the data starts on depending on which format the file is so that the column names are correct. I have ...
MedianRooster10

Discussions |
Oct 19, 2023 5:36 AM

1070 views | 1 replies

Previous
Next

Latest Discussions

Run radiobox using jsl

Hi, Is there a way to run the radiobox using set?Tried the following code but doesn't workNames Default To Here( 1 ); New Window( "Example", r1 = Radio Box( {"Red", "Green", "Blue"}, das = r1 << get selected; if(r1 == "Green", Caption("Green")) ) ); r1 << set( 2, runscript(1) );
Jackie_

Discussions |
Oct 19, 2023 11:14 AM

646 views | 1 replies
Automate importing files

I have imported an excel file using workflow and am editing the script to be more general. Within the import settings under Column names starts is a specific number but instead I want it to be when a specific condition is met (e.g. when row 5 column 2 says START with start being the column name). Any help in the right direction is very appreciated. The snippet of code is below with the importan...
MedianRooster10

Discussions |
Oct 19, 2023 9:36 AM

756 views | 2 replies
How do I change the number of decimals shown for a distribution plot?

Hi,We recently moved from JMP 11 to JMP 13, and now the output of DoE looks different. In particular, more decimal points are shown than before (see screenshot). We want to avoid redoing all previous reports, so is there a way we can set the number of decimals in the distribution?Any feedback is highly appreciated!Sasker
Sasker

Discussions |
Oct 18, 2023 9:52 AM

4072 views | 4 replies
How to use JSL to replace characters with special symbols in ""?

[{"ReqId":"200904","PoolId":"2001"}]How to[{\!"ReqId\!":\!"200904\!",\!"PoolId\!":\!"2001\!"}]Thanks!
lala

Discussions |
Oct 17, 2023 9:44 PM

1359 views | 6 replies
Get currently executing line number of script as a variable

I'd like to send progress messages to the log that include the currently executing line number of the script. If I never changed the script of course I could just hard-code the line number into the message. But when I add/delete lines in the course of editing, the line numbers change. So is there a function that gives you the currently executing line number, so I could incorporate something likeWr...
john_madden

Discussions |
Oct 17, 2023 5:32 PM

1108 views | 2 replies

Previous
Next

Latest Discussions

Is it possible to have independent x-axis ordering within x-axis groups in graph builder?

In the attached data table the saved script plots the chart below.I want the x-axis parameter bars to change in order with the highest number of fails appearing first within each week (i.e. a Pareto type plot within each week)I created a FailOrder column for ordering within each week, but it does not seem to do what I want. Is there a way, via JSL, to have the order of the parameters (Para) in asc...
Neo

Discussions |
Oct 17, 2023 7:33 AM

465 views | 0 replies
Strange behavior using GenReg and Forward Selection

Hi All, I'm hoping someone might be able to help me to understand what is causing some strange behavior when I use GenReg and the Forward Selection Estimation Method. So, I have some data that I'm running through GenReg with Forward Selection, where I have several model effects and a validation column as well. After performing the fit, I want to run some simulations on the Estimate column of t...
SDF1

Discussions |
Oct 2, 2023 9:06 AM

474 views | 0 replies
SIMCA classification method: what alternative options do I have in JMP and what are the pros/cons?

Hello, I am after a combination of guidance and education. I have recently come across SIMCA as a classification approach. I believe this is not something JMP can address at the moment so my question is, which alternative options can I explore to achieve a similar goal and what would be the advantages/disadvantages when compared to the SIMCA method? I am currently using JMP 17 Thank you very much...
CamillaLiscio

Discussions |
Oct 2, 2023 5:55 AM

744 views | 0 replies
What determines which data table is seen as "Associated Data" for New Window?

What determines which data table is seen as associated data for a new window? First drawn report and it's data table? Something else? Is there a way to change that associated table / determine on creation what it should be (without first creating some report which will be removed)? This example script will have the summary table as associated data, but I would like it to be the Big Class table. ...
jthi

Discussions |
Sep 21, 2023 9:44 AM

512 views | 0 replies
Using R - File path problem

I have difficult to get the filepath correct.
Error message says "Cannot open table in access or evaluation of ....(Filepath)"
Prometheus

Discussions |
Sep 17, 2023 10:46 PM

622 views | 0 replies