Lightdash home pagelight logodark logo
  • Book a demo
  • Login
  • Start for free
  • Start for free
Table calculation SQL templates
SQL templates
Docs
API
  • About Us
  • Community
  • Blog
  • Welcome to Lightdash
    • Welcome to Lightdash
    Getting started tutorials
    • Overview
    • Setting up a new project
    • Developing in Lightdash
    • Learning to explore data in Lightdash
    Guides
    • Exploring Data in Lightdash
      • Spotlight
      • Using Filters
      • Interacting with your dashboards
      • Pinning
      • Using the Slack integration
      • Scheduled deliveries
      • Alerts
      • Chart Version History
      • Formatting your fields
      • 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
    • Developing in Lightdash
    • Using the Lightdash CLI
    • Managing your Organization
    • AI Analyst
    • How to embed content
    References
    • Overview
    • Lightdash Development
    • Data Exploration
    • Lightdash CLI reference
    • Integrations
    • Admin
    • User
    • Embedding
    Self-hosting
    • Self-Host Lightdash
    • Lightdash Cloud vs. Self-Hosted
    • Self-host Lightdash using docker compose
    • Self-Host Lightdash with Restack
    • Updating Lightdash to the latest version
    • 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
    Formatting your fieldsPercent change from previous
    githubslacklinkedinx
    Powered by Mintlify