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 SQL is where a bulk of the magic happens in Atlassian Analytics—it’s what you’ll use to create your charts. It’s the full series of query and transformation steps taken to achieve your final chart. As the name suggests, we’ve made SQL visual, to empower users of all backgrounds to explore their data. It’s intuitive for business users, fast for power users, transparent for SQL pros, and flexible for programmers.
When you create a new chart, Visual SQL starts with an expanded query step in visual mode where you’ll edit and execute your initial query. From there, you can transform your query result with other Visual SQL steps, view the result sets of those transformations, and ultimately visualize those results to add to your dashboard and share with others.
Visual SQL is also used to create other resources in Atlassian Analytics, such as “Dropdown” controls and “Date slider” controls. Learn more about variable controls.
The image above shows an example series of Visual SQL steps. The “Query” step is first, followed by two “Rename column” steps, then a “Reorder columns” step, then a “Pivot” step, then a “Zero fill” step, and finally a “Chart” step.
Was this helpful?