Utilize the benefits of Excel-like Confluence spreadsheets!
  • 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
  • Cloud
    • Cloud
    • DC/Server
  • Provided macros and their main functions
  • How to insert and remove macros
  • Table Filter
  • Table Spreadsheet
  • Spreadsheet from Table
  • Table Spreadsheet Include
  • Chart from Table
  • Pivot Table
  • AI Table
  • Table Excerpt and Table Excerpt Include
  • Table Toolbox
  • Table Transformer
    • Default automatic presets
    • General syntax and SQL functions available
    • Custom Transformation - use cases with advanced SQL queries
      • Advanced table cells formatting
      • Aggregating and grouping 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
      • Data searching, filtration, and formatting with SQL
      • Merging columns with SQL
      • Merging/JOINing tables with SQL
      • Processing links with SQL
      • Setting conditions with SQL
      • Using multiple SQL statements
      • Using SQL with Jira Issues
      • Using regular expressions in SQL
      • Working with variables in SQL
    • Stylesheet tab - altering table display with CSS
    • Using AI assistant to construct SQL queries
    • Messages tab - customizing no-output notifications
  • Table from CSV
  • Table from JSON
  • Use cases
  • How to work with built-in and third-party macros
  • How to export macros and results
  • Configuring parameters of Table Filter, Charts & Spreadsheets
  • How to set the date format and worklog settings
  • Advanced App Edition
  • Migration Details
  • FAQ
  • Release Notes
  • Privacy and Data Collection Policy
  • VPAT (Product Accessibility)
  • Table Filter, Charts & Spreadsheets for Confluence
  • Table Transformer
  • Custom Transformation - use cases with advanced SQL queries
  • Current: Executing calculations with SQL
PDF

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

Download PDF

Download page Executing calculations with SQL.

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.