topic Re: i have data base of production batches and for each different batch i would like to find the max value in Discussions

i have data base of production batches and for each different batch i would like to find the max value

ymendel — Sat, 02 Dec 2023 16:19:59 GMT

I have data base of production batches .

For each batch the particle size was measured as a function of time .

I would like to create a new column in which the maximum time for that batch appears .

Re: i have data base of production batches and for each different batch i would like to find the max value

txnelson — Sat, 02 Dec 2023 17:42:51 GMT

Col Max( :time_hour, :batch number )

Re: i have data base of production batches and for each different batch i would like to find the max value

ymendel — Sat, 02 Dec 2023 17:49:39 GMT

thanks much

Re: i have data base of production batches and for each different batch i would like to find the max value

jthi — Sun, 03 Dec 2023 09:19:42 GMT

There are also two easy interactive solutions for this (other will result in same formula as Jim did provide you with).

Option 1

Right click on the column header which you wish to use for grouping (batch number) and go to New Formula Column and select Group By

Next right click on the column header which you wish to perform the calculation from (time_hour) and New Formula Column / Aggregate / Maximum (note that there is Group By [batch number])

This will create you a new formula column

Option 2

Go to Tables/Summary and use batch number as group and max(time_hour) for statistics

Press OK to create the summary table (I think Link to original data table must be enabled for this).

Select the Max(time_hour) column, then click on it again, wait a bit, move your mouse and you should see that it is being moved (this isn't very intuitive how this works)

Now drag and drop this column to your original data table and you should have those same maximum values there.

Practicing my "recording skills" so here is a video with both of those options

(view in My Videos)