475457_en-US

liliconcom

How to connect column switcher and local data filter together

Hi,

Here is my not quite working script.

test = Fit Group(
 Oneway(
  Y( :Max Discharge Capacity ),
  X( :Cathode Recipe.x ),
  Quantiles( 1 ),
  Means( 1 ),
  Box Plots( 1 ),
  Mean Diamonds( 0 ),
  X Axis Proportional( 0 ),
  Points Jittered( 1 ),
  Grand Mean( 0 ),
  
 ),
 
 Oneway(
  Y( :"Cycle Number (>0.3)"n ),
  X( :Cathode Recipe.x ),
  Quantiles( 1 ),
  Means( 1 ),
  Box Plots( 1 ),
  Mean Diamonds( 0 ),
  X Axis Proportional( 0 ),
  Points Jittered( 1 ),
  Grand Mean( 0 ),
  
 ),
 Oneway(
  Y( :"Discharge Capacity @ 50 Cycles"n ),
  X( :Cathode Recipe.x ),
  Quantiles( 1 ),
  Means( 1 ),
  Box Plots( 1 ),
  Mean Diamonds( 0 ),
  X Axis Proportional( 0 ),
  Points Jittered( 1 ),
  Grand Mean( 0 ),
 ),
 Oneway(
  Y( :"Remain % @ 50 Cycles"n ),
  X( :Cathode Recipe.x ),
  Quantiles( 1 ),
  Means( 1 ),
  Box Plots( 1 ),
  Mean Diamonds( 0 ),
  X Axis Proportional( 0 ),
  Points Jittered( 1 ),
  Grand Mean( 0 ),
  
 ),

 <<{Arrange in Rows( 4 )}
);
colpick=test << Column Switcher(
 :Cathode Recipe.x,
 {:Cathode Batch ID.x, :Anode Batch ID.x, :Electrolyte Recipe.x, :Anode Recipe.x, :Separator Recipe.x, :Separator Batch ID.x}
);
test << Local Data Filter(
 Add Filter(
  columns( colpick<< get current ),
  Display( colpick<< get current, N Items( 15 ), Find( Set Text( "" ) ) )
 )
);

The column switcher is created and works as expected.  What I would like to happen is when the column is switched that the local data filter is updated with the respective values of that column to allow the user to further refine their view of the data. I think I am close.  How should the local data filter be coded to get the column switcher column and then update?

 

Thanks in Advance

Andy

ScriptingRe: How to connect column switcher and local data filter together

Hi @Hegedus1  (Andy),  This might one help:  https://community.jmp.com/t5/Discussions/Column-Switcher-Local-Data-Filter-and-Ref-Line-Automatically/td-p/324936  

 

Re: How to connect column switcher and local data filter together

Thank you that is exactly what I needed.  And I would never of figured that out on my own.