Skip to content

• Column properties

Column Properties

Column properties are shown in the right pane of the data studio by clicking on any column that is included in the report.

The properties shown depend on the type of column. Dimensions will show different properties than measures and certain properties are only shown depending on the settings of other properties.

Caption

Displayed title that is shown in column headers, legends and tooltips.

The default value is sourced from the column metadata of the dataset.

Display As

Provides a means to override the column type defined in the dataset metadata. This can be useful to display the raw value of a field by transforming it into a string, or to convert from numbers to currency.

The column can be hidden from view by setting the display setting to not show, see below.

Don't Show

Hide the column from view in the result. You can still use the column data for filtering and for constructing derived columns.

String

Display data as a string. Strings are not formatted.

==Strings are typically used as Dimensions. See Aggregation.

Number

Display data as a number. Numbers are formatted using the browser built-in formatting functions using the locale of the workspace.

The built-in formatting can be overridden by specifying a custom format string in the dataset metadata or in the format string field.

Date

Display data as a date. Dates are formatted using the built-in formatting functions using the locale of the workspace.

The built-in formatting can be overridden by specifying a custom format string in the dataset metadata or in the format string field.

Currency

Display data as a currency. The currency value will be formatted using the browser built-in formatting functions using the locale of the workspace.

The built-in formatting can be overridden by specifying a custom format string in the dataset metadata or in the format string field.

Boolean

Display data as a boolean true/false value. This type of data may be rendered differently based on the selected visualization type.

Longitude

Longitudes are numerical values that have been flagged for use in a map visualization.

Latitude

Latitudes are numerical values that have been flagged for use in a map visualization.

Date Granularity

By default, the date granularity is automatic and will be determined based on the date range constraints of the report.

Dates are formatted using the built-in formatting functions using the locale of the workspace unless overridden by a custom format string in either the column properties or in the dataset metadata.

If the column has been constrained by a filter on the column itself, the system will look at the date range and make a determination of an appropriate date granularity to produce what would be a reasonable number of rows in the resultset every day in the range had a row and the column was the only dimensional row in the resultset.

The following logic is used:

Number of days in span Granularity
a week or less hourly
a year or less daily
four years or less monthly
anything greater yearly

Automatic

The date granularity will be automatically determined based on the active date range, if applicable. Defaults to daily granularity if no date range can be calculated.

Hour

Display the date in a full format including hour of the day.

Day

Display the date with daily granularity.

Month

Display the date with monthly granularity

Year

Display the date with only the year.

Custom

Set a custom date format. The date is formatted per the format string.

Aggregation

Specify if the all values with the same value should be grouped into a single line or not. Grouping by a column makes it similar to a dimension.

Group by this column

Enable aggregation of identical values into a single row. This has the effect of adding the column into the GROUP BY statement of the SQL query.

None

Do not group by this column. Values appear as they are returned from the underlying data.

Count

Count the number of values. This is the equivalent of SQL COUNT(colum)

Average Value

Return the average of the values in the group. This is the equivalent of SQL AVG(colum)

Summation

Return the summation of the values in the group. This is the equivalent of SQL SUM(colum)

Minimum Value

Return the smallest of the values in the group. This is the equivalent of SQL MIN(colum)

Maximum Value

Return the largest of the values in the group. This is the equivalent of SQL MAX(colum)

Default Value

Specify a default value when the value in the resultset is missing (or in database terminology a null value.)

Format String

Set a custom format. The value can be formatted using the Excel formatting language (ECMA-376). Custom formats can be constructed online.

Examples of date formatting:

Input Code Result
1-Jan-2019 yyyy 2019
1-Jan-2019 yy 19
1-Jan-2019 mmm Jan
1-Jan-2019 mmmm January
1-Jan-2019 d 1
1-Jan-2019 ddd Tue
1-Jan-2019 dddd Tuesday

Calculation

Transform the measure by applying a transformation. Calculated columns can be used to easily apply resultset wide adjustments to a specfic series of values.

None

No calculation is performed and the values are presented as they appear based on aggregation

Percent of Total

The sum of all of the values of the measure is calculated and the value of each row is set to the percentage of the total represented by the value in the row.

Running Total

Calculate a running total of the values in the columnn from top to bottom.

Moving Average

Calculate a moving average of the values in the column. The moving average is based on the average of the four prior values.

Column Filter

Filter the values of the current measure column. This is useful when looking at an aggregate of one of out of many dimensions.

Column filters are the equivalent of SQL such as COUNT(CASE WHEN column = 'VALUE' THEN 1 END)

Code Filter

Apply transformations to the column data after the query and aggregation steps. Code filters use JavaScript filter logic to make changes to the values of the resultset.