JSL- Formula for calculating column average for last x rows per ID
I am trying to create a column formula to calculate the average for the last 30 sets of data per cycle run (shown in the example below):I have been able to achieve this, however I would like to be able to calculate the average per "ID" rather than the entire data set per test cycle. The formula I have used is shown below:If( Row() == Col Max( Row(), :Cycle ),
Mean( As Column( "Output, mV" )[Index
...