357338_en-US

liliconcom

envelope calculate function

Hello

I have data were I calculate a column with the moving average using

Col Moving Average()

for a parameter.

I am wondering if there is a function to calculate the min and max envelope line of the data i am not aware of

or is it necessary to program it in jsl?

Best regards

 

 

 

Advanced Statistical ModelingRe: envelope calculate function

Hi,

This is the solution that Vince Faller (@vince_faller) posted in June (LINK)

This the formula for moving minimum:

Min( :DATA[Index( Min( Row() - 5 ), Row() )] )

Where :DATA is the data column in your table.

For moving maximum, just create another column with the same formula where "Min" is replaced by "Max"

Best

TS