Adapt my expression to Script

Ask a Question

Hello guys,

How can I adapt the following 2 expressions to run on Script?
It's taking too much time to recalculate on every chart changing, and would be much better to have it load with script.

= LINEST_M(Aggr(avg( If(DVPG > '18/03/2020', VDAF) ), STCK, DVPG ), DVPG )

=LINEST_R2(Aggr(avg(DISTINCT If(DVPG > '18/03/2020', VDAF)), STCK, DVPG),DVPG)

This is the chart where the expression can be found - The dimension is STCK:

Please, find below my project with a Sample Data.
Thanks

0 Replies