• Table Filter, Charts & Spreadsheets for Confluence
  • Table Filter, Charts & Spreadsheets for Confluence
  • Need Help
  • FAQ
  • Migration
  • Book Live Demo
  • Start Free Trial
  • Suggest Feature
  • For monday.com
  • DC/Server
    • Cloud
    • DC/Server
  • Table Filter, Charts & Spreadsheets for Confluence
  • Table Transformer
  • Custom Transformation - use cases with advanced SQL queries
  • Current: Executing calculations with SQL
PDF

Download PDF

Download page Executing calculations with SQL.

Executing calculations with SQL

Using formulas to calculate with SQL
Accounting for the monthly budget
Counting the definite value in a column
Calculating cumulative (running) totals
Calculating standard deviation / variance
Calculating the completion ratio
Calculating the number of distinct (unique) values by categories
Calculating the number of workdays in a period of time
Calculating time difference

Table Filter, Charts & Spreadsheets for Confluence Logo
Privacy Policy / Stiltsoft Europe App License Agreement / Stiltsoft website / Privacy and Data collection Policy
Copyright © 2025 Stiltsoft Europe • Powered by Scroll Viewport and Atlassian Confluence

Cookie Notice

This website uses cookies for analytics, personalization and advertising. By continuing to browse, you agree to our use of cookies.
Learn more

OK Don't track me.