Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
PNash
Level II

JSL for using a column group in a formula

Hi;

 

New to JMP / JSL.  I'm trying to add a formula column at the end of a set of data that calculates the STD DEV of the column data.  The header data will be variable, so I need a generic assignment of column numbers.

 

My script is obviously wrong, otherwise I wouldn't be here but this is what I was trying;

 

 

dt << Group Columns ("Weeks", Column (2), 26);
dt << New Column ("STDEV", Characteristic, Formula (std dev("Weeks")));

 

 

Any guidance is appreciated!  Thanks!

-Phil

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
PNash
Level II

Re: JSL for using a column group in a formula

Nevemind, figured it out!

dt << Group Columns ("Weeks", Column (2), 26);
colgrp = dt << get column group("Weeks");
dt << New Column ("STDEV", Numeric, Formula (std dev(colgrp)));

View solution in original post

1 REPLY 1
Highlighted
PNash
Level II

Re: JSL for using a column group in a formula

Nevemind, figured it out!

dt << Group Columns ("Weeks", Column (2), 26);
colgrp = dt << get column group("Weeks");
dt << New Column ("STDEV", Numeric, Formula (std dev(colgrp)));

View solution in original post

Article Labels

    There are no labels assigned to this post.