topic Re: How to create display box to select grouping column (Xaxis) for variability plots? in Discussions

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

jump — Sun, 14 Sep 2014 00:51:44 GMT

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

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

jules — Tue, 16 Sep 2014 03:33:18 GMT

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

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

jump — Tue, 16 Sep 2014 05:04:05 GMT

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?

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

jump — Tue, 16 Sep 2014 05:45:06 GMT

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

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

jump — Sun, 21 Sep 2014 18:49:11 GMT

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

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

ms — Mon, 22 Sep 2014 21:02:13 GMT

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

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

jump — Tue, 23 Sep 2014 02:29:37 GMT

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