Our documentation now lives on the Atlassian Support site at https://support.atlassian.com/analytics/resources/.
Add or remove columns
- Cat Africa
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 Ctrl (for Windows) then click 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.
Aggregation menu
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.
If you don’t want to group or aggregate a column, you can choose Unaggregated from the menu.
Reorder a column
To reorder the columns in your visual mode query:
Select and hold the column that you want to move.
Drag it to the target location. You’ll see a blue line to indicate where the step will be placed once you let go.
Remove a column
To remove a column from your query, hover over the column’s block and select the X that appears within its block.