Welcome to the JMP User Community!

Latest Discussions

• How to apply mathematical operations to selected rows only?

  Hello,           I am new to JMP and struggling to calculate % change in current for 5 different devices after 72hrs of stress testing as shown in the table below. The % change in current is calculated as = (current @ a given stress duration - current @ 0hr)/current @0hr*100This operation is quite straightforward in Excel but not sure how to apply the formula to selective rows? Any help will be gr...

  Bluegalaxy

  Discussions |

  Aug 16, 2022 7:54 PM

  1410 views | 2 replies

• How to script an aggregate column from a variable list of column references

  I have a list of columns that I need to aggregate automatically. Currently, what I'm trying is something like this, which isn't yielding any results.cols = {:col1, :col2, :col3} Eval(Eval Expr( dt << New Column( Formula(Minimum(Expr(cols)) ) )I've also tried generating this interactively and saving the column formula. It works, but gives me Minimum(:col1, :col2, :col3)which I'm not sure h...

  jconte

  Discussions |

  Aug 16, 2022 1:47 PM

  2782 views | 7 replies

• How to create an application with a data filter in the launch module?

  I'm trying to create an application to produce reports based on user input. I have some experience with writing scripting, but am getting stuck and I haven't used Applications before.I have tried to modify one of the example Applications that come with JMP, but none of these have a data filter in the launch module and what I have tried to do isn't working.Does anyone have an example of a simple ap...

  ckronig

  Discussions |

  Aug 16, 2022 11:41 AM

  3958 views | 10 replies

• JSL select rows near the maximum value of a column

  Hi,I have a data series shown in the screenshot below, and try to select only the data in the range of "x +/- 0.3" with the center at the maximum value of "y".I got an error message "The argument to SelectWhere did not evaluate to true or false, it is [0]..." from the highlighted line, as shown below. What is puzzling is that the last line worked when only 1 condition is applied.What is wrong with...

  CurseOfLizard13

  Discussions |

  Aug 16, 2022 10:45 AM

  1946 views | 4 replies

• How do you import JSONs that contain double nested arrays?

  I'm trying to import a number of JSON files that contain double nested arrays (see example below). The arrays don't follow a consistent format, there could be numerous objects in each array or none at all. I want to have one score per row as shown below.How can I get the data in this format using the import tool? Also, the name of the prediction is not always spelt the same e.g. sometimes it's "Sm...

  BagOfMiningLion

  Discussions |

  Aug 16, 2022 9:41 AM

  4320 views | 6 replies