// Sample dataLOAD *, Div(ts, 10) as tf;LOAD *Inline [ prog, app, ts, v Q, c, 10, 0.5 P, a, 21, 0.3 P, b, 22, 1 Q, c, 23, 0.2 P, a, 24, 3 Q, c, 25, 2 P, b, 36, 0.1];// This expression gives the "last known value [v]" (sorted by timestamps [ts])// for every entity [app], for the whole period <= selected timeframe [tf].FirstSortedValue( {<tf={'<=$(tf)'}>} DISTINCT TOTAL <app,tf> v, -ts)// -----------------------------------------------// as-of table sampletf_aotf_2:LOAD tf, tf + IterNo() - 1 as aotf2Resident main_dataWhile IterNo() <= 2 and tf + IterNo() - 1 <= 3;