Products

Atlassian Analytics Support

  • Knowledge base
  • Resources
  • Search
  • Log in
    • View account
    • View requests
    • Log out
  • ...

Knowledge base

Products

  • Jira Software

    Project and issue tracking

  • Jira Service Management

    Service management and customer support

  • Jira Work Management

    Manage any business project

  • Confluence

    Document collaboration

  • Bitbucket

    Git code management

See all

Resources

  • Documentation

    Usage and admin help

  • Community

    Answers, support, and inspiration

  • System Status

    Cloud services health

  • Suggestions and bugs

    Feature suggestions and bug reports

  • Marketplace

    Product apps

  • Billing and licensing

    Frequently asked questions

  • Log out
  • Log in to account
  • Contact support
  • Training & Certification
  • Cloud Migration Center
  • GDPR guides
  • Enterprise services
  • Atlassian partners
  • Developers
  • User groups
  • Automation for Jira
  • Atlassian.com
  • Page

  • View in Confluence
  • Edit Page
  • Viewport

  • Manage Viewport
  • Confluence

  • Dashboard
  • Space Directory
  • People Directory
  • Atlassian Support
  • Analytics Knowledge Base
  • Use Visual SQL to calculate values

Use Visual SQL to calculate values

Related content

  • No related content found

Still need help?

The Atlassian Community is here for you.

Ask the community

  • Include NULL values when applying functions
  • Extract values from a JSON string
  • Count keywords and characters in strings
  • Count distinct totals and percentages
  • Calculate a percentage
  • Omit data using an anti-join
  • Calculate a running total
  • Combine columns in Visual SQL
  • Find the date difference between rows
  • Filter by complete days

Last modified on Aug 13, 2022

Was this helpful?

Yes
No
Provide feedback about this article

In this section

  • Include NULL values when applying functions
  • Extract values from a JSON string
  • Count keywords and characters in strings
  • Count distinct totals and percentages
  • Calculate a percentage
  • Omit data using an anti-join
  • Calculate a running total
  • Combine columns in Visual SQL
  • Find the date difference between rows
  • Filter by complete days

Related content

  • No related content found
Powered by Confluence and Scroll Viewport.
Atlassian
  • Notice at Collection
  • Privacy Policy
  • Terms of Use
  • Security
  • © Atlassian