Is there a way to call a user function with different row filters

TheRealYeti

Sorry. I do not know how to best describe it in the title but I will try to elaborate what I currently have and what I wanted to achieve:

What I have:

So I have this function that computes for Col Min, Max and Mean

col_stats = Function( { COL_NAME }, {},
     curr_dt   = Cuurent Data Table();
     min_val   = Col Min   ( curr_dt:Eval(COL_NAME));
     max_val   = Col Max   ( curr_dt:Eval(COL_NAME));
     mean_val  = Col Mean  ( curr_dt:Eval(COL_NAME));
     Eval List({min_val, max_val, mean_val});
);

What I want to achieve:

I want to be able to call the col_stat function, filtering the data using the combination of a certain list or lists.

The number of lists can change based on user, for the example below the user select temp and vcc (user can add frequency etc)

temperature = {-40, 0, 25, 100};<BR />vcc&nbsp;=&nbsp;{1.2,&nbsp;1.26,&nbsp;1.32};

I want to be able to get the Min Max Mean using the col_stat function for

-40 and 1.20V

-40 and 1.26V

and so on.

 

If the number of list are known, I know I can do a double for loop to iterate thru the combination of two lists but I want to expand it in such a way that the user can add more list

 

Hope I explained it well.

 

txnelson

My thinking on this, is that you need to make a pretty simple change to your function to make it work only on rows that are selected in your data table.  The Show() with the call to your function is assuming that data table Big Class is open.

col_stats = Function( {dt, COL_NAME},
	{defaultlocal},
	min_val = Col Min( If( Selected( Row State( Row() ) ), column(dt, COL_NAME ), . ) );
	max_val = Col Max( If( Selected( Row State( Row() ) ), column(dt, COL_NAME ), . ) );
	mean_val = Col Mean( If( Selected( Row State( Row() ) ), column(dt, COL_NAME ), . ) );
	Return( Eval List( {min_val, max_val, mean_val} ) );
);


show(col_stats(dt,"height"));

By doing your calculations only on the selected rows, you can use the functionality of 

     dt << Select Where()

to define whatever combinations of items you want, and then to call the function and get the results.

And, you don't have to force everything into a single Select Where.  If you look at the definition of the Select Where, you will see that you can dynamically build your final overall selection passing several Select Where() clauses, and specifying whether to expand of contract from the current selection.(i.e. If all of the rows with -40 are currently selected, you can tell JMP to add the further qualification of "only the vcc of 1.20)