Lightdash home page
Search...
⌘K
Ask AI
Book a demo
Login
Start for free
Start for free
Search...
Navigation
Table calc SQL templates
SQL templates
Docs
dbt guides
API
About Us
Community
Blog
Introduction
Welcome to Lightdash
Setting up a new project
Explore and analyze
Lightdash BI quickstart
BI feature guides
AI agents
Lightdash MCP
Spotlight
Chart types
Scheduled deliveries
Alerts
Slack app
Filters
Formatting fields
Custom charts
Custom fields
Custom tooltips
Version history
Promoting content
Table calculations
Table calc SQL templates
Overview
Percent change from previous
Percent of previous value
Percent of column total
Percent of group/pivot total
Rank in column
Running total
Rolling window
Build your semantic layer
Lightdash semantic layer
Developer quickstart
Developer guides
Semantic layer reference
Workspace and user management
Spaces
Pinning
Personal access tokens
Admin
Integrations
dbt
Slack
Google Sheets
Embedding
Embedding quickstart
Embedding reference
React SDK
Self-hosting and deployment
Self-Host Lightdash
Lightdash Cloud vs. Self-Hosted
Docker compose
Restack
Updating Lightdash
Customize deployment
Contact
FAQs
Contact Us
Table calc SQL templates
SQL templates
Use our SQL templates to get started with your table calculations!
Percent change from previous
Percent of previous value
Percent of column total
Percent of group/pivot total
Rank in column
Running total
Rolling window
Raise issue
Table calculations
Percent change from previous
Assistant
Responses are generated using AI and may contain mistakes.
