JMP User Community

Latest Discussions

Creating a series column based on other column values.

Hello, I need help with creating a column, using JSL, that fill a series and increase by one when a triggered by another column value. Like column 2 below, every time there is a “Yes” in column 1 it increases by 1 the value in column 2.
Hope I am clear enough. Column 1Column 2No1No1No1No1Yes2No2No2No2No2No2Yes3No3No3No3
ileshem

Discussions |
Jun 9, 2023 10:20 AM

1353 views | 3 replies
JMP heatmap Color display wrongly with nominal data

HiJMP seems to have a bug to show multi colors in one cell.When I select "other" group, all green cell (other group) should be marked with dark color, but the cell I circled was not.When I select the cell I circled previously, it is supposed to mark other group in legend. But it marked "edge" and "void" groups.Any one knows how to display this multi color correctly, thank you in advance.
Edwinchiang

Discussions |
Jun 9, 2023 8:07 AM

1376 views | 2 replies
Failed to convert varchar value ro datatype int in query (query worked before but now not)

Hi , I used JMP DATAbase Query to query data from tables. the same query worked find until today it suddenly complains of issue of converting char to int. I'm not sure why it worked before and nothing has changed, but now not it is not working. So I started to work on the custom query to find a way to add script to convert. This is my first time with the custom sql query. how can I convert the t2....
dadawasozo

Discussions |
Jun 9, 2023 7:30 AM

751 views | 0 replies
Kaplan-Meier plot assistance

Good Afternoon, I'm trying to generate a very simple Kaplan-Meier plot with necropsy day and date. I'm using the survival tab but the graph appears as if there are 3 animals remaining at the 86d time point and the graph starts at 0.8 not 1. Please assist. I know this is probably something very simple but I have tried for over a day and cannot figure out how to fix it! The data is attached. There...
perrydl

Discussions |
Jun 9, 2023 7:19 AM

1229 views | 2 replies
Reliability Forecast

I am trying to predict warranty returns but want to use the Bayesian estimation tools to update the warranty predictions. No matter what I do I can’t seem to get the warranty predictions to update after applying a Bayesian model. Is it possible to use the Bayesian tools with Reliability Forecast? If not, how would you recommend going about adjusting those return predictions for the updated posteri...
AcceptanceGnu69

Discussions |
Jun 9, 2023 6:16 AM

1110 views | 1 replies

Previous
Next

Latest Discussions

Creating a series column based on other column values.

Hello, I need help with creating a column, using JSL, that fill a series and increase by one when a triggered by another column value. Like column 2 below, every time there is a “Yes” in column 1 it increases by 1 the value in column 2.
Hope I am clear enough. Column 1Column 2No1No1No1No1Yes2No2No2No2No2No2Yes3No3No3No3
ileshem

Discussions |
Jun 9, 2023 10:20 AM

1353 views | 3 replies
Failed to convert varchar value ro datatype int in query (query worked before but now not)

Hi , I used JMP DATAbase Query to query data from tables. the same query worked find until today it suddenly complains of issue of converting char to int. I'm not sure why it worked before and nothing has changed, but now not it is not working. So I started to work on the custom query to find a way to add script to convert. This is my first time with the custom sql query. how can I convert the t2....
dadawasozo

Discussions |
Jun 9, 2023 7:30 AM

751 views | 0 replies
Kaplan-Meier plot assistance

Good Afternoon, I'm trying to generate a very simple Kaplan-Meier plot with necropsy day and date. I'm using the survival tab but the graph appears as if there are 3 animals remaining at the 86d time point and the graph starts at 0.8 not 1. Please assist. I know this is probably something very simple but I have tried for over a day and cannot figure out how to fix it! The data is attached. There...
perrydl

Discussions |
Jun 9, 2023 7:19 AM

1229 views | 2 replies
Extracting control limits from column info

I am trying to extract control limits from column info, I have used the below code to extract spec limits, but if I do the same for control limits, it does not work because it treats everything as one element in the list. p = c << get property( "Spec Limits" );
plst = Eval List( {Arg( p, 1 ), Arg( p, 2 ), Arg( p, 3 )} ); Any ideas? Thanks!
Abby_Collins14

Discussions |
Jun 8, 2023 2:21 PM

1290 views | 3 replies
Help to concatenate 3 columns with labels rather than values

Hello, I wanted to check if anyone has a solution for concatenating 3 columns with the labels of those columns rather than the values? ThanksRitesh
riteshj

Discussions |
Jun 7, 2023 11:04 AM

1561 views | 4 replies

Previous
Next

Latest Discussions

Failed to convert varchar value ro datatype int in query (query worked before but now not)

Hi , I used JMP DATAbase Query to query data from tables. the same query worked find until today it suddenly complains of issue of converting char to int. I'm not sure why it worked before and nothing has changed, but now not it is not working. So I started to work on the custom query to find a way to add script to convert. This is my first time with the custom sql query. how can I convert the t2....
dadawasozo

Discussions |
Jun 9, 2023 7:30 AM

751 views | 0 replies
Main Menu("command") - return value?

If I open a file via open("filename"), the command returns a reference to the data table which can be used as dt = open("filename");If I trigger open viadt = Main Menu("open")it doesn't return a reference to the data table. In general, is there a way, when triggering a command from the Main Menu, to get the return value?e.g. a reference to a data table for a user defined file loader - or an error ...
hogi

Discussions |
Jun 7, 2023 8:42 AM

643 views | 0 replies
Selecting multiple legend entries - how?

Sometimes in a GraphBuilder it's difficult to select multiple entries in the legend, especially along the idea:- select a first entry- press shift *)- while clicking on another entry.If everything works fine, at the end both entries plus the entries in between will be selected. But there are cases where either the first selected entry or all entries are deselected at the end.
Is there a feature beh...
hogi

Discussions |
May 24, 2023 3:08 PM

648 views | 0 replies
how to read the output from Johnson-Neyman plot and floodlight analyisis?

hi,I have got an add-in from https://community.jmp.com/t5/JMPer-Cable/Who-what-why-and-how-Tools-for-modeling-and-visualizing/bc-p/624293#M842 to implement floodlight analysis through Johnson-Neyman Plot. according to the table of the example from the linkage above; what does "_c" mean? such as "meaning_c" and overwhelming_c"? focus on my own study, I got a moderator called "SE" which is a contin...
Rongyu_Kuang

Discussions |
Apr 23, 2023 8:56 AM

1210 views | 0 replies
Goodness of Fit statistics for GLM Probit Fit: Deviance or Pearson?

Which GoF statistic is best to use (Pearson or Deviance) when the results disagree? Is one better suited for Probit than the other? I'm using JMP Pro 17.0.0
DBerger

Discussions |
Apr 18, 2023 12:50 PM

787 views | 0 replies