This seems like such a simple thing but for the life of me I can not seem to make it work.
I have a table with numerous columns. I ask the user to choose columns through a column dialog for the X factors in a variability chart. Then I want to plot all of the other columns versus those factors. The problem I am having is that the result of a column dialog is a list of column names, not strings but actual name references. I can not seem to figure out how to use that variable in the variability chart syntax. Do I need to make it into a string? Do I need to evaluate an expression? I would love some help.
Clear Symbols();
dt0 = Current Data Table();
//choose column for plotting
r_coldlg = Column Dialog( col_id = Col List( "X , Factor" ) );
ls_factor= r_coldlg["col_id"];
//for each column (in this example, columns 12-14
For( i =12, i <= 14, i++,
r_var = Variability Chart( Y( Column( dt0, i ) ), X(ls_factor) );
);
thanks
Heather