Welcome to the JMP User Community!

Latest Discussions

• Tutorial for building 1-click dashboards

  Does anyone know of good tutorials for how to build interactive 1-click dashboard using JSL? For example, I would like to build a user interface which allows the user to select an item from a dropdown list and display some sort of visualization charts based on the user selection. Thanks,Simon

  simon_2

  Discussions |

  Mar 19, 2021 1:03 PM

  2257 views | 2 replies

• Transposing from WIDE to LONG and a formula question

  Hi--two somewhat related questionsI have used SPLIT to transform a long file to a wide file, but I have a slightly more complicated situation where I want to STACK/transpose a wide file to a long file. I have a dataset with a unique subject ID, and then several hundred columns/variables. The variable names are the exact same with the exception that Year 1 ends '2', Year 2 ends in '3', etc. Is ther...

  plfazeli

  Discussions |

  Mar 19, 2021 8:16 AM

  1922 views | 3 replies

• CMD window for logging never shows up while using RunProgram

  I got an issue while using "RunProgram" to call my exe, a CMD window for logging is supposed to appear, but it never shows up.  The CMD window can normally pop up when I manually run it. Is there anyone who can help me solve the issue? Thanks in advance : )    JSL code: RP = Run Program( Executable( exefilepathRoot || "CommonalityEngine\PyScript\get_data_from_cache.exe" ), Opti...

  baiyun

  Discussions |

  Mar 19, 2021 6:54 AM

  1903 views | 4 replies

• Fill in Missing Data Based on previous column [cell] value

  I apologize for this redundant question about column fill but for the life of me i can't find any of the previous topics. I have a data table that is filled out in an incomplete manner. I need to fill the missing cells below each value with its predecessor. I know it is a Column Formula script that uses the Lag() and Row() but can't find the correct syntax.   

  Yngeinstn

  Discussions |

  Mar 19, 2021 6:50 AM

  1961 views | 1 replies

• Making a Mixture Design that Does Not Sum to 1.0

  I am trying to make an I-optimal mixture design with 3 components that add to 0.883, with the remainder 0.117 being a fourth, but constant, ingredient. I know a possible work around is to normalize my constraints, but to avoid confusion in reporting the information I would like to have the three components add to 0.883. I have tried to add linear constraints (shown in the attached screen shot) but...

  David_J

  Discussions |

  Mar 19, 2021 6:49 AM

  1560 views | 2 replies