JMP User Community

Latest Discussions

JSL how to change the color of a single column in a Pareto plot?

Hi All, I'm interested in using JSL to change the color of a single bar (or perhaps multiple bars) in a Pareto Plot and not rely on the interactive row selection of a data table to do so. I found these two helpful discussions here and here, but they're not quite what I'm after. I can of course make the graph using Graph Builder instead of the Pareto Plot platform, that's not the problem necess...
SDF1

Discussions |
Oct 9, 2023 7:54 AM

1386 views | 2 replies
DoE Model issues Augmentation

Dear JMP community, currently we are setting up DoE models based on two experimental blocks.The first block was a Custom DoE Design with 22 runs containing main effects and quadratic effects from 7 factors. The second block was an augmented design containing main effects, quadratic effects and all possible two factor interactions with 16 runs (for a total of 38 runs separated in 2 blocks).In the s...
I-love-jmp

Discussions |
Oct 9, 2023 5:34 AM

3541 views | 9 replies
Difference despite same numbers...

Hello, Today I have a non-understanding question.I have 2 columns of products prices. I wanted to check that same numbers are the same in the 2 columns so I created a formula column with the formula If( :"Mean(Final Price)"n != :prixLot / 100,
"Yes",
"No"
) Even if same number was in the 2 columns (exactly the same including decimals) then the formula returned me a "Yes". So I did difference column: ...
mgerusdurand

Discussions |
Oct 9, 2023 5:10 AM

1223 views | 2 replies
How to filter rows of a data table with dynamical number of conditions?

Hi everybody, I would like to select rows based on the entries of selected rows from another table. Below a code snippet. The last row is not valid, but it should clarify what I mean. selected_row_idx = DT << Get Selected Rows; measurement_starts = DT:MeasurementStart[selected_row_idx]; measurement_ends = DT:MeasurementEnd[selected_row_idx]; DTmeas << Select Where(measurement_starts[1] <= :TimeSt...
Robbb

Discussions |
Oct 9, 2023 2:27 AM

1672 views | 2 replies
How do I filter categorical data that does not meet my location restriction?

Hi, I am doing a project that involves getting a model ready from airbnb listing data to the predict price of Broward County airbnb listings. I am trying to exlude and hide rows within my data that are not in Florida as there are many listings that are from different countries and states. Is there a way to do this without having to go row by row? This is categorical character data.
jmessina944

Discussions |
Oct 8, 2023 6:37 PM

1653 views | 4 replies

Previous
Next

Latest Discussions

DoE Model issues Augmentation

Dear JMP community, currently we are setting up DoE models based on two experimental blocks.The first block was a Custom DoE Design with 22 runs containing main effects and quadratic effects from 7 factors. The second block was an augmented design containing main effects, quadratic effects and all possible two factor interactions with 16 runs (for a total of 38 runs separated in 2 blocks).In the s...
I-love-jmp

Discussions |
Oct 9, 2023 5:34 AM

3541 views | 9 replies
How do I filter categorical data that does not meet my location restriction?

Hi, I am doing a project that involves getting a model ready from airbnb listing data to the predict price of Broward County airbnb listings. I am trying to exlude and hide rows within my data that are not in Florida as there are many listings that are from different countries and states. Is there a way to do this without having to go row by row? This is categorical character data.
jmessina944

Discussions |
Oct 8, 2023 6:37 PM

1653 views | 4 replies
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

1475 views | 3 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

1262 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

1357 views | 1 replies

Previous
Next

Latest Discussions

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

618 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

1124 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

733 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

847 views | 0 replies
Data Access Handler

How can I define a function that is activated when Jmp accesses the data in a column.I found the Event Handler option in the Column Properties. But there I can only define functions for the cases: Click, and Mouseover (and I can set the color of the link)- but there are no settings for Write Data Access and Read Data Access. Applications:- To check the performance of code (https://community.jmp.c...
hogi

Discussions |
Sep 16, 2023 12:21 AM

560 views | 0 replies