Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
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.
To pull data using a visual mode query, you’ll need to select columns from the schemas of your connected data sources.
Add a column
To add a column, select +Add column in the “Columns” section of your query. To find and add a column from the list, you can do any of the following options:
Search for it using the search bar.
Navigate through the schema browser.
Select a column from the table preview of the schema browser when you select a table.
To add multiple columns at a time without the schema browser closing between each selection, hold Command (for Mac) or Control (for Windows) then select the columns you wish to add. This works when selecting columns from either the schema browser or the table preview.
After adding a column, you might see some schemas, tables, or columns become disabled in the schema browser when you try to add another column. This means the currently selected columns aren’t connected to those disabled items. You may need to update your data source’s foreign keys to connect the tables or add another "Query" step to query and merge additional columns.
When you add a column to the query, you can specify how to group or aggregate its values. Each column has the following:
Applied group or aggregation: Selecting it opens the column’s aggregation menu. Each column has a default aggregation, which you can change in its column properties.
Aggregation menu: A set of group or aggregation options available for the column. The available options depend on the column’s data type. Learn more about the available group and aggregation options.
If you don’t want to group or aggregate a column, select Unaggregated from the menu.
Remove a column
To remove a column from your query, hover over the column in the query and select the X that appears within its block.
Was this helpful?