Welcome to the JMP User Community!

Latest Discussions

• Trying to have Graph Builder automatically plot data from Filtered Data Table Query

  Hello all, JMP 16 user here. I have an add-in that pulls data from a work database and creates a table. In the particular file I'm interested in, there's data going back 20 years, but I only want data from the last 6 months. I managed to build a query that filters the data from the source table and puts it into a new subset table. The query filters based on any date range I put in with the filter ...

  JMPnoob

  Discussions |

  Jul 18, 2022 3:09 PM

  2364 views | 4 replies

• perform calculation evaluation in associative array

  Hello, I am trying to get a function to return a standard deviation calculation stored inside an associative array, my code will only return the expression of the associative array and not the calculation.  would you please tell me what is wrong with my code.  cvf= Max(replist);// my cvf in the file is 8cv=Associative Array();cv[6]=Associative Array({(Std Dev(5,6,7,8,9,10))});cv[8]=Associative Arr...

  swu2

  Discussions |

  Jul 18, 2022 3:04 PM

  14067 views | 11 replies

• Listbox Graphs

  I would like to get a listbox plot similar to the script below but with  a different data format. My data looks more like the following table where all of the data to plot is in the first two columns. I want the list portion in the list box to be test count, and when I click on a test count, it produces a plot for both forward and reverse. It looks like it may be possible with a bivariate plot usi...

  trevorphysics

  Discussions |

  Jul 18, 2022 11:00 AM

  2545 views | 6 replies

• Quantifying how many rows selected

  This has to be possible...  Is there an easy way to quantify the number of rows selected (and ideally the percent of rows selected) and display it on a dashboard?  I know that I can go back to the raw data table and see the number Selected in the Rows area - I'd like to pull that onto a dashboard... Specific example - here's gas flow through a panel data.  How many cells are highlighted as a fract...

  CSSanderson

  Discussions |

  Jul 18, 2022 10:53 AM

  2202 views | 4 replies

• Force column from CSV import as Character not Numeric Date

  Hello, My input CSV data files have a Character column in the format of: "##.##.##"."##" can be anything from 0 to 99. The issue that I am having is that for most of these combinations, when I import the CSV using a basic "Open(filename)" command, the column converts it to a numeric date type which is not useful for me. I have made patch fixes using Month/Day/Year column functions but I was intere...

  caseofmondays

  Discussions |

  Jul 18, 2022 9:25 AM

  2669 views | 2 replies