Get started with Atlassian Analytics
Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
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:
Display name
The alias of the column that you see in visual mode queries
Updating a column’s display 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
Was this helpful?