Welcome to the JMP User Community!

Latest Discussions

• Col score & Col N unique

  Add dense ranking to Ranking Tie and Col Rank functions  Col N Categories (:green_heart:)    new in JMP19 : New in Graph Builder for JMP 19    very helpful : )  
  
  Details you should be aware of: 1) excluded rows are not included in the calculation
  [ very useful, along the idea of Formula Editor: meaningful results with excluded rows , nevertheless:  somewhat inconsistent, in view of the behavior ...

  hogi

  Discussions |

  Oct 8, 2025 4:00 AM

  626 views | 4 replies

• Bar Graphs in Graph Builder - new in JMP19 ...

  In Graph Builder, users do not need to drag a value onto the y-axis in order to create a bar graph.
  Without specifying a Y value, JMP will count -- or calculate an aggregate value.
  Which one? For some of the settings, this depends on the version of JMP being used.     comparison JMP18 vs. JMP19:     Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class Families.jmp" ); Graph Builder( Variab...

  hogi

  Discussions |

  Oct 7, 2025 10:09 PM

  432 views | 3 replies

• How can I use the text entered on textbox as variables on SQL?

  I'm a beginner with application builders and I want to achieve the following: I'm currently retrieving data from a database using SQL with a specific time period. However, instead of directly modifying the SQL code to change the period, I want to be able to change it via a GUI. I'm currently executing this with JSL, and I want to replace the [HERE] part of the SQL query. Example JSL: // Get a hand...

  TamedZebra

  Discussions |

  Oct 7, 2025 10:06 PM

  870 views | 7 replies

• Workarounds

  very simple tasks - JMP says NO.   TaskJMP saysworkaroundswishimplementedadd column via Tables/Updatecolumn existsrename one of the columnsAllow Update platform to create new columns if they already exist in the table to be updatedv19copy a cellformula column- recode to dummy column | copy cell | delete dummy column
  - screenshot | OCREdit Pane allows for text copy even if no edit                   ...

  hogi

  Discussions |

  Oct 7, 2025 3:51 PM

  299 views | 0 replies

• Recode a value in a column with a formula instead of a static value

  The original value that is in the table that I want to recode will always be 01/01/1900.  I want to recode that to today's date.  This only returns a blank, and not today's date.  Any idea what I need to change? Thanks! Transfers << Begin Data Update; Transfers << Recode Column( Transfers:OrderDate, {Map Value( _rcOrig, {-126144000, short date(today())}, Unmatched( _rcNow ) )}, Update Propertie...

  Phil_Nash

  Discussions |

  Oct 7, 2025 1:22 PM

  1243 views | 2 replies