Welcome to the JMP User Community!

Latest Discussions

• Guidance on appropriate analyses

  I am trying to relearn JMP and the appropriate stats to use. I would really appreciate help trying to determine which analyses are most appropriate given the dataset. I have a dataset of whale sightings collected from aerial and vessel surveys with 3 different environmental covariates [distance from shore (km), depth (m), and Sea Surface Temperature (SST degrees C)]. I have attached the summary st...

  ZZS

  Discussions |

  Feb 5, 2021 7:04 AM

  3087 views | 5 replies

• Custom SQL Query: LEFT OUTER JOIN, not joining properly? | JMP 15

  Hello,I'm trying to join WeeklyDOSummary (yellow) and PondMaster_Investigations (green). I've highlighted the columns selected on my custom SQL query.From WeeklyDOSummary, I am left outer joining PondMaster_Investigations on date = date and pond = pond. Although you can't see it clearly in the photos, there are data in the Ave and NO23 columns where there are common dates (ranging from 05/07/2020 ...

  dason

  Discussions |

  Feb 4, 2021 5:10 PM

  2665 views | 3 replies

• How to control size of Text Box, Border Box or Outline Box?

  I'm having hard times trying to control size of my Display Boxes.So, I have a number of reports where there is a Graph Builder of certain size.For some reports there is nothing to report (missing files) and I want to place a text box saying files are missing instead of the Graph Builder.I would like to match the size of it to the size of Graph Builder in other reports, and I cannot.None of the mes...

  miguello

  Discussions |

  Feb 4, 2021 5:09 PM

  3745 views | 5 replies

• Tablebox() - how to set focus to specific row?

  Hi, lets say I have a Tablebox() with many rows.  (e.g. 1000 rows)  In this case it does an automatic vertical scroll bar.  (good as there are many rows)  But how to set focus to say the n=685th row as focus?  Is there a specific command or method?  In this way, by focus, I mean a command that will automatically scroll the vertical scroll bar to the n=685th row.  (so that a user doesn't have to ma...

  djhanson

  Discussions |

  Feb 4, 2021 3:32 PM

  1901 views | 3 replies

• Saving a table with empty numerical values as JSON results in invalid JSON primitive?

  If a save a table with empty values in one of the numerical columns like this:New Table( "testEmpty", Add Rows( 2 ), New Column( "Col1", Character, "Nominal", Set Selected, Set Values( {"test", "test"} ) ), New Column( "Col2", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [., .] ) ) )as a JSON file, it will result in this:[ { "Col1" : "test", "Col2" : . }, { ...

  miguello

  Discussions |

  Feb 4, 2021 1:05 PM

  2930 views | 3 replies