Learn how to connect and manage your connected Atlassian data and external data.
Learn how to create insightful charts and dashboards with your organization’s data.
Learn how to use Visual SQL to create queries and transform data for making charts.
Need feedback on data? Learn how to share charts and dashboards with teammates so they can leave comments.
Learn how to grant resource access to the people who need it.
Learn how to manage your workspace and how to monitor your workspace activity.
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.
After adding some columns to your visual mode query, you can open the query’s advanced drawer to configure it further.
The advanced drawer contains a few notable features:
The advanced drawer is the collapsible section at the bottom of the visual mode query editor. The advanced drawer is collapsed by default. To expand or hide the advanced drawer, select the chevron ( or ).
Apply a nested sort to the columns in your visual mode query
Your query is automatically sorted by the order you’ve added your columns. You can change the query sort in the advanced drawer.
To add a sort block, select +Add sort, select the column to sort by, then choose the sort direction (Asc for ascending or Desc for descending).
To remove a sort block, select the X within its block.
To edit a sort block:
Select the column name to choose a different column
Select Asc/Desc to change the sort direction
You can only sort by columns you’ve added to the “Columns” section of your query.
Set the number of rows returned from your query
It’s important to note that Atlassian Analytics queries all rows in your data source to calculate your result set, but the number of rows returned from that result set is limited to the number you provide in the Limited to…rows field.
By default, to improve performance while creating and testing your chart, the row limit for the returned results of your query is set to 1,000. When you’re finished testing, you may want to increase this limit to ensure that your chart results are not truncated by this limit. The maximum row limit for queries is 1,000,000.
The maximum row limit for each chart type varies, so you may need to use a “Limit rows” step later in your Visual SQL.
A read-only preview of the auto-generated SQL query
When you’re using visual mode, Atlassian Analytics auto-generates the SQL query to be executed in the background. The auto-generated SQL query uses the appropriate syntax for the underlying data source type.
This is also a great way to learn some basic SQL—simply edit your visual mode query and watch how the auto-generated query changes.
Was this helpful?