Window functions

Calculations in Sigma

Mandy Gray

Solutions and Enablement Lead, Aimpoint Digital

Window functions

Images_representing_window_functions.png

  • Window functions used for rolling calculations like moving averages and cumulative totals
Calculations in Sigma

Helping out Oakmark Bank

Oakmark_Bank_New_Accounts.png

Calculations in Sigma

Helping out Oakmark Bank

Varying_accounts_monthly.png

Calculations in Sigma

Helping out Oakmark Bank

Window_function_to_apply.png

Calculations in Sigma

Window functions in Sigma

  • Moving window functions

    • MovingAvg
    • MovingSum
    • MovingCount
    • MovingMin
    • MovingMax

  • Cumulative window functions

    • CumulativeMax
    • CumulativeSum

  • Shifting window functions

    • First
    • Last
    • Lag

  • Ranking window functions

    • RowNumber
    • Rank
    • RankDense

 

Calculations in Sigma

DEMO

Calculations in Sigma

Let's practice!

Calculations in Sigma

Preparing Video For Download...