WINDOW_SUM(): WINDOW_SUM(SUM([Sales])) : Sum across window defined by compute using

WINDOW_AVG(): WINDOW_AVG(AVG([Profit])) : Average across window

WINDOW_MIN(): WINDOW_MIN(MIN([Sales])) : Minimum across window

WINDOW_MAX(): WINDOW_MAX(MAX([Sales])) : Maximum across window

RUNNING_SUM(): RUNNING_SUM(SUM([Sales])) : Cumulative total

RUNNING_AVG(): RUNNING_AVG(AVG([Profit])) : Cumulative average

RUNNING_MIN(): RUNNING_MIN(MIN([Profit])) : Cumulative minimum

RUNNING_MAX(): RUNNING_MAX(MAX([Profit])) : Cumulative maximum

LOOKUP(): LOOKUP(SUM([Sales]),-1) : Reference relative row

FIRST(): FIRST() : Index offset from first row in partition

LAST(): LAST() : Offset from last row

INDEX(): INDEX() : Sequential row number

RANK(): RANK(SUM([Sales])) : Rank with gaps

RANK_DENSE(): RANK_DENSE(SUM([Sales])) : Dense rank

RANK_PERCENTILE(): RANK_PERCENTILE(SUM([Sales])) : Percentile rank 0-1

PERCENTILE(): PERCENTILE([Sales],0.9) : 90th percentile within window

WINDOW_PERCENTILE(): WINDOW_PERCENTILE(SUM([Sales]),0.75) : Percentile across window

NTILE(): NTILE(4) : Bucket rows into N tiles

WINDOW_STDEV(): WINDOW_STDEV(SUM([Sales])) : Std dev across window

WINDOW_VAR(): WINDOW_VAR(SUM([Sales])) : Variance across window