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.
Visual mode makes it easy for people with minimal SQL knowledge to query their data sources. You focus on adding the necessary columns and query filters for your chart, and Atlassian Analytics generates the SQL query for you, which you can view at any time by:
switching to SQL mode or
opening the SQL preview in the advanced drawer
Looking to write your own SQL query? Learn how to create queries in SQL mode.
Select a data source
Before you can start building your query, you need to decide from where to query the data. Select the data sources dropdown next to the name of your query, then select one of your connected data sources.
If you don’t see any data sources, connect one to Atlassian Analytics or reach out to your organization admin for access.
Select visual mode
After selecting a data source to query, select Visual in your query to use visual mode.
Add columns and query filters
Run your query
When you feel like your query is ready, select Run query to execute it. When visual mode is the active query mode, Atlassian Analytics executes its auto-generated SQL query. The result table and chart preview will update with your query results.
You can also use Cmd + Enter (for Mac) or Ctrl + Enter to run your query.
After running your first query, you can start adding other Visual SQL steps to further transform your data. View all the available Visual SQL steps.
Switching between visual and SQL mode
Making changes and executing the query in visual mode updates the query in SQL mode, but this isn’t true for the reverse—making changes and executing the query in SQL mode doesn’t affect what’s shown in visual mode.
If you’re switching between visual mode and SQL mode, your changes to visual mode don’t impact your returned results until you rerun your query from visual mode.
Rerunning the query in visual mode may override changes you’ve made in SQL mode.
Executed SQL query and completion time
After executing your query, you can view the amount of time it took to complete next to the “Query finished” button. Selecting the completion time shows the executed query, including the values used for any variable controls referenced in your query.
If you rerun a query without making any changes to it, Atlassian Analytics doesn’t send a new query to the data source. It will use cached results from the original query and note that in the execute SQL query.
Was this helpful?