Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.lightdash.com/llms.txt

Use this file to discover all available pages before exploring further.

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