Welcome to the JMP User Community!

Latest Discussions

• Newb Question - Basic Sequencing in a column

  I'm a beginner in JMP and coding as a whole. I'm trying to figure out how I can make sequence of 0, 25, 50, 100, to repeat 8 times.   I tried Sequence(0,100,25,8) and obviously 75 shows up as well.    And I cannot for the life of me figure it out.    Chatgpt gave me the following code:    If(Mod(Row(), 4) == 0, 0, If(Mod(Row(), 4) == 1, 25, If(Mod(Row(), 4) == 2, 50, If(Mod(Row(), 4) =...

  ControlAlpaca51

  Discussions |

  Oct 8, 2023 1:06 PM

  1077 views | 3 replies

• Help with this simple script of fit y by x

  Hello. I try to study the relationship of a quantitative variable with multiple quantitative variables. I wrote this script but it doesn't work. I show you the script and the error message. Thank you in advance. Script Names Default To Here(1); dt = Current Data Table(); numericColNames = dt << get column names(string, numeric); For(i = 38, i <= N Items(numericColNames), i++, Bivariate(Y(:Name("E...

  gallardet

  Discussions |

  Oct 8, 2023 9:38 AM

  1679 views | 6 replies

• How to get non-duplicate column names from the "leaf label formula" of decision tree model?

  For example, use the following JSL to get the Leaf Label Formula.Extract the column names from the formula in the first 10 rows.Thanks!d0 = Open( "$SAMPLE_DATA/Equity.jmp" ); p=Partition( Y( :BAD ), X( :LOAN, :MORTDUE, :VALUE, :REASON, :JOB, :YOJ, :DEROG, :DELINQ, :CLAGE, :NINQ, :CLNO, :DEBTINC ), Validation Portion( 0.3 ) ); p<<go;Wait(2); p << save leaf label formula;

  lala

  Discussions |

  Oct 7, 2023 8:02 AM

  1007 views | 3 replies

• for each group find out which value is missing in a specific column, then create a new row with the missing value for that group with 0 in the count column as a corresponding value for that row

  I have 4 columns in the mock data set (File attached below). The column "Companys" is grouped by column "Month-Year" and "State". Each "Companys" column value is associated to a value in column "Sectcor". I want find what values are missing in each group of Month-Year and State Column for example Sector "DK" has Companys "C" and "D" Associated to it but for group Jan-2021, CA we have 2 rows associ...

  j0rg

  Discussions |

  Oct 6, 2023 1:54 PM

  1020 views | 1 replies

• Change Single Bar Color

  Hi All, I have a seemingly simple question that I cannot find the answer to. I have made a bar graph and would like to custimze the each bar graph fill color individually. The graph is cost on y axis and car make on x axis, with each car make having two years. The reason is I have a general fill color depending on the year (2017&2018), but would like to highlight certain car make a different color...

  GERblob

  Discussions |

  Oct 6, 2023 1:20 PM

  10067 views | 3 replies