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 and limit the rows of your visual mode query
Specify how you want to sort your query results and how many rows to return.
What are the generated and executed queries for visual mode?
Get read-only previews of the auto-generated SQL query and the literal SQL query sent to your data source.

Was this helpful?

It wasn't accurate

It wasn't clear

It wasn't relevant

Additional Help