Loop, how? Need only in script: average for all dates less current

[warfollowmy_ver]

Need help!

Need only in script: average for all dates less current. Example in excel.

Please help! It is necessary only in the script!

[sunny_talwar · Accepted solution]

May be this:

Table:

LOAD * INLINE [

    Date, sub1, sub2, SUM

    1/1/2016, 1, 1, 1

    1/2/2016, 1, 1, 2

    1/3/2016, 1, 2, 3

    1/4/2016, 2, 2, 4

    1/5/2016, 2, 3, 5

    1/6/2016, 2, 3, 6

    1/7/2016, 3, 4, 7

    1/8/2016, 3, 4, 8

    1/9/2016, 3, 5, 9

    1/10/2016, 3, 5, 10

];

FinalTable:

LOAD Date,

  sub1,

  sub2,

  SUM,

  Temp1,

  Temp2,

  Temp1/Temp2 as [Avg Group by Date];

LOAD *,

  RangeSum(Peek('Temp1'), SUM) as Temp1,

  RangeSum(Peek('Temp2'), 1) as Temp2

Resident Table

Order By Date;

DROP Table Table;

[warfollowmy_ver]

Thank you so much!