SQL templates

Use our SQL templates to get started with your table calculations!

Looking for a simpler alternative to raw SQL? Check out the built-in row functions and pivot functions — they handle common patterns like accessing previous rows and working across pivot columns without needing to write window function SQL.

Percent change from previous

Percent of previous value

Percent of column total

Percent of group/pivot total

Rank in column

Running total

Rolling window