I want to create a list box with column name and feed the selected value to “WHJ” position in script below....
1. How to create a list box with columns? Part of the main list box.
2. How to assign a value selected from list box to a plot in Xaxis grouping. (I tried assigning to a variable, but it does not take variable in X(grouping columns ))
window = New window ("data Analysis",
<< modal,
V list Box( /// main list box
Text Box("Select PARAMETER to run analysis by:", << set font style("Bold")),
Analysis_By = combo box({"WHJ, "ZZZ"}),
Spacer Box(Size(50,0)),
Text Box("Enter directory where you to save :", << set font style("Bold")),
save_dir = Text Edit Box("", << Justify Text (Left), <<Set Width(500)),
Text Box("Enter Identifier(e.g. Week, Date.) :", << set font style("Bold")),
ID = Text Edit Box("", << Justify Text (Left), <<Set Width(500)),
Text Box(""),
spacer box(Size(100,0)),
Text Box("\!N"),
H list box(
Spacer Box(Size(30,0)),
Text Box("plots", << set font style("Italic"), << set font size(11)),
group1 = List Box({"","ABC","XYZ", "MNO”}),
}
plot = lkl_lkh << Variability Chart(
SendToByGroup( {:Pin_group == "Input"} ),
Y( :Test_Data ),
SendToByGroup( {:Pin_group == "Input"}, Y( :Test_Data ) ),
SendToByGroup( {:Pin_group == "Output"}, Y( :Test_Data ) ),
X( :Corner, :Leak, :WHJ),
Std Dev Chart( 0 ),
Points Jittered( 1 ),
AIAG Labels( 0 ),
Connect Cell means(0),
Show Box Plots(1),
Variability Summary Report(1),
Thanks
Not entirely sure what you're trying to do, but lists of columns can be used to pass variables to a variability chart. And Col Dialog() is one way to obtain lists of user selected columns. See the simple example below:
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
var = Column Dialog(
y = ColList( "y", Max Col( 1 ) ),
x = ColList( "Grouping variables", Max Col( 5 ) )
);
dt << Variability Chart( Y( var["y"] ), X( var["x"] ) );
Edit: improved and simplified code
Hi Prasen,
As I'm working on this I'm realizing it would be really helpful to have a version of the dataset you're using. Do you have a dataset with these columns you're willing to share?
Julian
btw. thx ... i am going to try the solution you gave me in the email....
.Is there a direct email, where i can share data?
Hey Julian,
so i created a dataset and wrote a small subset of the script where you select your column name (VARIABLE).
i tried method you recommended, but it does not work for me. I have modified Big Class data to serve as an example.
i have created a new column called category. So we can switch between Column (:sex) or Column (:Category) on X axis in a Variability plot
thanks
Not entirely sure what you're trying to do, but lists of columns can be used to pass variables to a variability chart. And Col Dialog() is one way to obtain lists of user selected columns. See the simple example below:
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
var = Column Dialog(
y = ColList( "y", Max Col( 1 ) ),
x = ColList( "Grouping variables", Max Col( 5 ) )
);
dt << Variability Chart( Y( var["y"] ), X( var["x"] ) );
Edit: improved and simplified code
Thank you .. Sir ... worked.!! i was looking for something like this.
Hey Julian,
Let me know if you have any feedback. i am still stuck with the issue and would like to find a solution , rather than creating multiple scripts for each grouping column.
Thx