Welcome to the JMP User Community!

Latest Discussions

• if filename contains help

  Hello I can't seem to open jmp data tables in a folder in which filename  contain "Values"the log isn't telling me anything helpful either ...i am sure its something obvious but i can't see the error!Names Default to Here( 1 ); Set Default Directory( "C:\Users\" ); files = Files In Directory( "C:\Users\" ); For( i = 1, i <= N Items( files ), i++, If( contains( "Values",files[i]), ...

  AlexS

  Discussions |

  Aug 19, 2020 3:33 AM

  1804 views | 2 replies

• Rank Unique

  I want to calculate a new column to rank a column uniquely. Below are the example output that i want to achieve. But by using the JSL rank formula doesn't help me to achieve what i want. Can anyone please advise me?  The formula i use is Col Rank(:Label) LabelRankWhat I wantNVM_VMAX_PRG_EVENR2_DCMP[1],80376,max11NVM_VMAX_PRG_EVENR2_DCMP[1],80376,max21NVM_VMAX_PRG_EVENR2_DCMP[1],80376,max31NVM_VMAX...

  OneNorthJMP

  Discussions |

  Aug 19, 2020 2:54 AM

  2669 views | 5 replies

• making a graph of a sequence

  Hi all,I have a data table that presents a sequence over time and records only when there is a change (un equal time intervals).I would like to produce a graph with time on the horizontal axis and parallel horizontal lines representing the three categorical variables (place, condition and condition 2). The colors along the lines will represent the different categories of place and conditions.I man...

  ron_horne

  Discussions |

  Aug 19, 2020 2:13 AM

  18875 views | 16 replies

• Add formula column to tabulate table with JSL

  Hi,Is there some way to add formula column to tabulate table?Formula column have to use final summary statistics.For example, if I have Mean and StdDev columns, I would like to add a column of their sum (Mean * StdDev).This is just example. My final goal is to add CP, CPK to tabulate...  Thanks.

  tom_abramov

  Discussions |

  Aug 19, 2020 1:20 AM

  1690 views | 1 replies

• Select table, then columns

  Hi, I am new using JMP and JSL and I am having trouble creating a script that selects a table, then 2 columns and then do something with that. Here is an example Names Default to Here( 1 ); // Make list of current tables dtNames = {}; For(t=1, t<=NTable(), t++, InsertInto(dtNames, DataTable(t) << getName); ); // Select the table nw = New Window("Test", <<Modal, PanelBox("Pick a table", d...

  teoten

  Discussions |

  Aug 19, 2020 12:38 AM

  3210 views | 6 replies