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.

Use visual mode to create a query in Visual SQL

What is visual mode?
Learn more about visual mode queries.
Add or remove columns
Understand the different ways to add a column to a visual mode query and how to remove a column.
Add or remove query filters
Add or remove a filter condition in a visual mode query.
Preview your schema in visual mode
View the first ten rows of data in a table when searching for columns in a visual mode query.
Sort, limit, and preview your visual mode query
Expand the advanced drawer to preview the underlying SQL query and change the sorting and row limits.
Operators for filter conditions
View the list of available filter operators for each data type.
Group and aggregate functions
View the list of group and aggregate operators you can use in queries and other steps.

Was this helpful?

It wasn't accurate

It wasn't clear

It wasn't relevant

Additional Help