BookmarkSubscribeRSS Feed
jump

Community Trekker

Joined:

Sep 13, 2014

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
ms

Super User

Joined:

Jun 23, 2011

Solution

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

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 REPLIES
julian

Staff

Joined:

Jun 25, 2014

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

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

jump

Community Trekker

Joined:

Sep 13, 2014

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

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?

jump

Community Trekker

Joined:

Sep 13, 2014

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

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

ms

Super User

Joined:

Jun 23, 2011

Solution

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

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

jump

Community Trekker

Joined:

Sep 13, 2014

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

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

jump

Community Trekker

Joined:

Sep 13, 2014

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

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