Cascade Library
⌘Ctrlk
Cascade Library
    • Welcome to Cascade
    • Workspaces
    • Build Your First Workflow
    • Build Your First Data App
    • Overview
    • Dynamic Workflows
    • Global Variables
    • Data Locker
    • Scheduling
    • Webhooks
    • Run Logs
    • Workflow Deployment
    • Connecting Cascade to your database
    • Amazon S3
    • Azure Blob Storage
    • BigQuery
    • Google Sheets
    • MySQL
    • Postgres
    • Redshift
    • SQL Server
    • Snowflake
    • Tableau Server
    • Import
    • Clean
    • Transform
    • Merge
    • Predictive Modeling
    • Flow
    • Code
    • Visualize
    • Publish
    • Functions
      • Aggregate Functions
      • Conversion Functions
      • Date/Time Functions
      • Logical Functions
      • Math Functions
      • Table Functions
        • ENCODE
        • INDEX
        • INDEXBY
        • FILLNULL
        • FIRSTBY
        • GENERATEUNIQUEID
        • LASTBY
        • LOOKUP
        • MATCH
        • NTH
        • OFFSET
        • OFFSETBY
        • PREVIOUSVALUE
        • RANK
        • RANKBY
        • RECORDID
        • ROLLINGAVERAGE
        • ROW
        • RUNNINGAVERAGE
        • RUNNINGMAX
        • RUNNINGMIN
        • RUNNINGSTDEV
        • RUNNINGTOTAL
        • WINDOWAVERAGE
        • WINDOWMAX
        • WINDOWMIN
        • WINDOWCOUNT
        • WINDOWSUM
        • SEQUENCE
        • WINDOWMEDIAN
        • WINDOWSTDEV
        • WINDOWSTDEVP
        • WINDOWSTDEVS
        • WINDOWVAR
        • WINDOWVARP
        • WINDOWVARS
        • WINDOWCORR
        • WINDOWCOVAR
        • WINDOWCOVARP
        • WINDOWCOVARS
        • SMOOTHEDAVERAGE
      • Text Functions
    • Building Expressions
  • Cascade FAQs
  • Change Log
For the complete documentation index, see llms.txt. This page is also available as Markdown.
  1. Functions & Expressions
  2. Functions

Table Functions

ENCODEINDEXINDEXBYFILLNULLFIRSTBYGENERATEUNIQUEIDLASTBYLOOKUPMATCHNTHOFFSETOFFSETBYPREVIOUSVALUERANKRANKBYRECORDIDROLLINGAVERAGEROWRUNNINGAVERAGERUNNINGMAXRUNNINGMINRUNNINGSTDEVRUNNINGTOTALWINDOWAVERAGEWINDOWMAXWINDOWMINWINDOWCOUNTWINDOWSUMSEQUENCEWINDOWMEDIANWINDOWSTDEVWINDOWSTDEVPWINDOWSTDEVSWINDOWVARWINDOWVARPWINDOWVARSWINDOWCORRWINDOWCOVARWINDOWCOVARPWINDOWCOVARSSMOOTHEDAVERAGE
PreviousSECNextENCODE

Last updated 5 years ago

Was this helpful?

Was this helpful?