• Products
  • Documentation
  • Resources

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.

Column properties

When you edit a column, you can view its properties and edit some of them to improve how you and your team use the column in Visual SQL. Columns have the following properties:

Nickname

The display name of the column that you see in visual mode queries

Updating a column’s nickname won’t break any existing charts using this column because the SQL name of the column won’t change.

Description

A column definition you can add that people can view when building charts

People will see this description whenever they hover over the column name in the table preview of Visual SQL queries.

For newly added columns or data source connections, Atlassian Analytics can import the column’s comment if it exists in your data source and automatically set it as the column’s description.

Query

The column’s SQL name, which you use when referencing the column in SQL mode queries

SQL type

The column’s data type in your data source

Type

This property is only available for number data types.

It’s difficult for Atlassian Analytics to automatically recognize Unix timestamps when pulling schemas from databases. In the Atlassian Analytics schema, they’re simply marked as number data types.

Change the type to Unix timestamp (in seconds) to specify if the column is, in fact, a Unix timestamp. This will apply a FROM_UNIXTIME function to the column when it’s used in visual mode queries.

Foreign key

If the column is a foreign key, you can specify

  • the schema (if there are multiple), table, and column of the primary key it references

  • The type of join used to connect the tables (“inner join” is the default)

Learn more about how to connect tables using foreign keys.

Grouping

Specifies if the column is a measure or dimension

Measures are the numerical values that quantify the data set that you want to dig into. They’re usually fields containing quantitative information. For example, a sales revenue column is a measure because you can find the sum or average the data. You can think of these as the y-axis in a chart.

Dimensions are how you want to categorize or break up the data. They’re usually fields that cannot be aggregated and contain qualitative, categorical information. For example, sales region, employee, location, or date are dimensions. You can think of these as the x-axis in a chart.

If the column is a measure, you’ll see aggregate operators in the column’s aggregation menu when you select the column in visual mode queries.

If the column is a dimension, you’ll see group operators in the column’s aggregation menu when you select the column in visual mode queries.

Default aggregation

This property is only available for columns whose grouping is measure.

If you commonly use one particular aggregation for a measure, you can set it as the default in the Atlassian Analytics schema. The default aggregation you set is automatically selected when you use the column in a visual mode query.

The available options are:

  • Unaggregated

  • Count of distinct

  • Count of all

  • Total sum

  • Average

  • Minimum

  • Maximum

The following options are also available for some data sources:

  • Standard deviation

  • Variance

Additional Help