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.
If you want to see the kinds of data stored in a particular table, you can get a convenient table preview with the first ten rows of data. When adding a column or a filter, an interactive table preview will appear in the schema browser when you select a table from the list. Hovering over any of the table’s columns in the dropdown will highlight the column in the table preview and the dropdown navigation.
Column data types
Each column in the schema browser has an icon corresponding to the column’s data type.
A comma-separated list of values contained within square brackets ([ ])
Either a true or false value, where true is 1 and false is 0
Because boolean columns shows true values to 1 and false values to 0 in the result table, boolean columns become number data types after the query.
A date value with the following format: YYYY-MM-DD
An example date value is 2022-05-23.
A timestamp value with the following format: YYYY-MM-DD HH:MM:SS.SSS
An example datetime value is 2022-05-23 01:45:09.303.
A numeric value
A text value
Was this helpful?