Window

AVG_WINDOW

SnowflakeSnowflake

Menghitung moving average menggunakan window function. Ideal untuk trend analysis.

Tipe hasil: FLOAT

Syntax

SQL
AVG(expression) OVER ([PARTITION BY ...] [ORDER BY ...] [frame_clause])

Parameter

expressionNUMERICwajib

Kolom numerik untuk averaging

Contoh Penggunaan

7-Day Moving Average

SQL
1SELECT
2  date,
3  sales,
4  ROUND(AVG(sales) OVER (
5    ORDER BY date
6    ROWS BETWEEN 6 PRECEDING AND CURRENT ROW
7  ), 2) as moving_avg_7d
8FROM daily_sales;

7-day moving average untuk sales.

Kembali ke Snowflake Functions