List the value for Max Date?

UberBock

I have a data table that has a date column, median_resultval column and reagentMLot_sublot .  What I would like is that for the Max(Date) what is the value by reagentMLot_sublot.   So for each reagentMLot_sublot I would like to list the median_result value for the Max Date and the median_result for the min date.

 

So if on the min day the median value is 0.1 and on the max day it is 0.2 I would like columns that list that.  Issue is that maybe on a date between the min and max it was 0.4.  

 

I tried using the Col Max (median_resultval, reagentMLot_sublot, Col Max(date)) and that didn't work (for the max column).  The other column it would be Col Min (median_result, reagentMLot_sublot, Col Min(date)).

 

 

txnelson

This little script will give you a data table with all the min and max date rows with their values of median_resultval

names default to here(1);
dt=current data table();

// Sort the data by reagentMLot_sublot and Date
dtSort = dt << sort(by(:reagentMLot_sublot, :Date),order(ascending,ascending));
dtSort << clear rowstates;

// Loop through the data finding all rows that are not the minimum date or the maximum date
// and delete them
// Row 1 will always be a minimum date, so start with row 2
For( i=2,i<=NRows(dtSort) - 1,i++,
	If( dtSort:reagentMLot_sublot[i] == dtSort:reagentMLot_sublot[i-1] &
		dtSort:reagentMLot_sublot[i] == dtSort:reagentMLot_sublot[i+1],
		Row State( i ) = Selected State( 1 );
	)
);

dtSort << delete rows;

You should be able to take it from there, and display it in the form you want it to be displayed.