cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
jump
Level II

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 (Alumni) ms
Super User (Alumni)

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

View solution in original post

6 REPLIES 6
julian
Community Manager Community Manager

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
Level II

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
Level II

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 (Alumni) ms
Super User (Alumni)

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
Level II

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
Level II

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