Atlassian Support

/

Atlassian Analytics (beta)

/

/

Query and transform data with Visual SQL

Atlassian Analytics is in open beta

Only customers with a Cloud Enterprise plan for Jira Software or Jira Service Management have access to Atlassian Analytics.

Learn about Visual SQL

What is Visual SQL?
Learn more about Visual SQL and how to use it to transform your data for charts.
Visual SQL steps
View the list of Visual SQL steps you can use.
Create and manage Visual SQL steps
Add, edit, remove, and reorder Visual SQL steps.
Group and aggregate functions
View the list of group and aggregate functions you can use in queries and other steps.
Operators for filter conditions
View the list of available filter operators for each data type.
Guided formulas
View a list of guided formulas you can use to make custom columns.
Custom formulas
View the kinds of SQLite functions you can use in custom formulas.
SQLite date and time functions
Use SQLite functions to modify dates and timestamps.
SQLite string functions
Use SQLite functions to manipulate string values.
Keyboard shortcuts
Speed up your resource-building process by using keyboard shortcuts.

Was this helpful?

It wasn't accurate

It wasn't clear

It wasn't relevant

Additional Help