Subscribe Bookmark RSS Feed

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

Highlighted
jump

Community Trekker

Joined:

Sep 13, 2014

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

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

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

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

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

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

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

jump

Community Trekker

Joined:

Sep 13, 2014

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