How to create display box to select grouping column (Xaxis) for variability plots?

[#1]

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

[#2]

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

[#3]

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?

[#4]

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

[#5 · Accepted solution]

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

[#6]

Thank you .. Sir ... worked.!!  i was looking for something like this.

[#7]

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