Our documentation now lives on the Atlassian Support site at https://support.atlassian.com/analytics/resources/.
What is visual mode?
- Cat Africa
Queries are the cornerstone for creating charts. This is where you’ll pull the data you want to show. All charts must start with an initial query. To help you remember this, all new charts always have the first "Query" step conveniently added and expanded.
Atlassian’s analytics offering makes it easy for users with minimal SQL knowledge to query their data sources. With visual mode, you can focus on simply adding the necessary columns and filters for your chart. We generate 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
1. Choose a data source
Before you can start building your query, you need to decide from where to query the data. Choose one of your connected data sources by selecting the data sources dropdown.
2. Select visual mode
To use visual mode, select Visual in your query.
3. Add columns and query filters
Pull the data you need for your chart by adding columns and query filters to your visual mode query.
4. Execute your query
When you feel like your query is ready, select Run query to execute it. When visual mode is the active query mode, the auto-generated SQL query is executed. 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.
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 re-execute your query from visual mode. Also, be aware that re-executing 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 “Run query” button. Selecting the completion time shows the executed query, including the values used for any variable controls referenced in your query.
