I am wondering how to create a column in a JMP table that is the running total of another column (which I may need to reference via the column name as a string). That is, if I have a column with the following data: 1 2 3 4 5 I would want to create a column with a formula whose contents would work out to 1 3 6 10 15 Currently I have this loop, working from a list of names of columns to take the running total of: For(i = 2, i <= numCols, i++,   colName = colNames;   col = New Column("Cumulative " || colName,   Formula(Summation(j = 1, Row(), As Column(ColName) ))   ); ); This appears to work, but is very slow and if I create multiple columns, they all end up with the same data somehow. What is the best way to do this? ... View more

I currently have a script to produce the following plot. The call that finally produces it looks like this: chart = Bivariate( Y( :Log10 Reads , :Log10 Writes ), X( :Bin ), Nonpar Density,   Send To Report(   Dispatch( {}, "Bivar Plot", Framebox, {Frame Size(plotWidth, plotHeight)}),   Dispatch({}, "1", ScaleBox, {Format("Best", 10), Min(xMin), Max(xMax), Inc(xInc),                                  Minor Ticks(1), Rotated Labels("Horizontal")}),   Dispatch({}, "2", ScaleBox, {Format("Best", 10), Min(yMin), Max(yMax), Inc(yInc),                                  Minor Ticks(1), Rotated Labels("Horizontal")})   ) ); My question is simply, how do I programmatically change the title of the grouping of bivariate plots (circled below) to something customized and more descriptive? ... View more

I am trying to transpose a table with a known Label column name, but Transpose column names that are only known at runtime. I have been trying for hours to figure out how to do this, but the task is greatly complicated by JSL mistaking the Transpose command for the matrix Transpose function and he Columns() argument to it for the function that gets the names of all columns in the table. In the following code, the list columns is populated with the names of the columns I want to transpose. //Create the transpose expression transposeExpr = Expr(Transpose(Columns(), Label(:Wt or Rd))); //Pull the Columns argument expression out of it (this keeps me from having to create it myself and have it mistaken for the Columns() function) columnsExpr = Arg(transposeExpr, 1); For(i = 1, i <= numColumns, i++,     Insert Into(columnsExpr, Name Expr(As Column(colNames))); ); Remove From(transposeExpr, 1); Insert Into(transposeExpr, Name Expr(columnsExpr), 1); cdt = Current Data Table(); cdt << Transpose(Name Expr(columnsExpr), Label(:Wt or Rd)); However, this still doesn't appear to work because columnsExpr still evaluates to a list of names of all the columns in the current table, rather than the Columns argument with actual references to the table. (I think it interprets these references are arguments to Columns the function) Can anyone please explain what I am doing wrong? ... View more