Logo
Submit a request
Sign in
  • Home
  • Release Notes
  • {[{category.name}]}

    • {[{section.name}]}
      • {[{article.title}]}

Window Functions

Window Functions are special functions where the result is dependent on the order and grouping of rows.

  • ArrayAgg
  • CAGR
  • CumeDist
  • CumulativeAvg
  • CumulativeCorr
  • CumulativeCount
  • CumulativeMax
  • CumulativeMin
  • CumulativeStdDev
  • CumulativeSum
  • CumulativeVariance
  • FillDown
  • First
  • Lag
  • Last
  • Lead
  • ListAgg
  • MovingAvg
  • MovingCorr
  • MovingCount
  • MovingMax
  • MovingMin
  • MovingStdDev
  • MovingSum
  • MovingVariance
  • Nth
  • Ntile
  • Rank
  • RankDense
  • RankPercentile
  • 1
  • 2
  • ›
  • »
Logo
We are rewriting the rules of analytics. Sigma empowers domain experts to join the data conversation, answer the toughest questions, and drive insights.
Links
  • Sigma Home
  • About Us
  • Contact
Support
  • Documentation
  • Function Index
Contacts
  • support@sigmacomputing.com
© Sigma Computing