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