Lightdash home pagelight logodark logo
  • Book a demo
  • Login
  • Start for free
  • Start for free
Docs
dbt guides
API
  • About Us
  • Community
  • Blog
  • Introduction
    • Welcome to Lightdash
    • Setting up a new project
    Explore and analyze
    • Quickstart
    • Guides
      • AI agents
      • Spotlight
      • Using Filters
      • Interacting with your dashboards
      • Pinning
      • Using the Slack integration
      • Scheduled deliveries
      • Alerts
      • Chart Version History
      • Formatting your fields
      • How to promote content
      • Table calculation 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
    • Reference
    Build your semantic layer
    • Developer quickstart
    • CLI quickstart
    • Guides
    • Reference
    Workspace and user management
    • Guides
    • Reference
    Integrations
    • dbt
    • Slack
    • Google Sheets
    Embedding and SDKs
    • 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 calculation 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
    How to promote contentPercent change from previous
    githubslacklinkedinx
    Powered by Mintlify
    Assistant
    Responses are generated using AI and may contain mistakes.