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 an early access program
Only people who are part of this invite-only early access program have access to Atlassian Analytics.
If you’re not sure which join to use to merge your queries, here are brief descriptions and illustrations for each available join type:
Combines the columns from all result sets on one or more common columns when possible, and includes all data from both result sets
You can also select whether or not to include NULL match rows.
Combines the columns on a common column (one or more leftmost columns) when possible, and only includes data for the columns that share the same values in the common columns.
Combines the columns on a common column (one or more leftmost columns) when possible, returning all rows from the first result set with the matching rows in the second result set. The result is null in the second result set when there is no match.
Stacks the result sets on top of each other without grouping or combining the data. Use unions to generate tabular lists of data for printing or viewing.
To remove duplicate rows, select the Distinct checkbox.
If you select to include query names, this adds an extra column titled Layer to your result set. It labels each row with name of the query that it came from.
Results in a table with all possible combinations of your result sets together. This can result in enormous tables, so use a cross join with caution. For example, only use it when your result sets return single values.
Was this helpful?