format

Syntax
Properties
Examples

Formats can also be set on a per-query basis using visualization configuration, using the same format types.

Grouping is not impacted when format is used, as formatting is applied after SQL runs. To handle grouping with truncation, use ROUND() or FLOOR().

Syntax

<dimension_name>:
  format: <format_name>

Properties

dimension_name

object

The name of the dimension. Dimension names must:

Be unique within the view
Start with a letter
Contain only alphanumeric characters and underscores

Hide dimension_name properties

format

string

The type of formatting to apply to dimension values. Can be a numeric, currency, or time format.Numeric and currency formats default to two decimal places, with the exception of id. You can explicitly set decimal places by appending _<number_of_places> to a numeric or currency format. For example, format: number_4, format: big_1, format: usdaccounting_0.When decimal length isn’t set, decimals will be truncated to the shortest possible length for each row.Numeric formats

Format	Example	Notes
`number`	1,234.50 (`number_2`)
`percent`	24.4% (`percent_1`)
`id`	123450	Numbers, no commas
`billions`	1.20B (`billions_2`)
`millions`	5.6M (`millions_1`)
`thousands`	8.90K (`thousands_2`)
`big`	5.60M; 1.23K; 12.23 (`big_2`)	Uses `millions` if `>1M`; `thousands` if `>1000`; otherwise `number`

Currency formats

Format	Example	Notes
`accounting`, `usdaccounting`, `euraccounting`, `gbpaccounting`	$(1,234.50) (`usdaccounting_2`)
`currency`, `usdcurrency`, `eurcurrency`, `gbpcurrency`	-£1,234.50 (`gbpcurrency_2`)
`bigcurrency`, `bigusdcurrency`, `bigeurcurrency`, `biggbpcurrency`	€5.60M; €1.23K; €12.23 (`biggbpcurrency_2`)
`financial`	(1,234.50) (`financial_2`)	Does not contain a currency mark

Time formats

Format	Notes
d3 time formats	Individual timeframe elements can be formatted using `timeframe_metadata`. Refer to the Examples.
`"%Y-%m"`
`"%Y-%m-%d"`
`"%Y-%m-%d %H:%M:%S"`

Examples

Currency format

sale_price:
  format: currency_2

Big number format

revenue:
  format: big_2

Time format with timeframe metadata

created_at:
  timeframe_metadata:
    month:
      format: "%Y-%m-%d"

filter_single_select_only

group_by

Getting started

Manage content

Analyze data

Deliver content

Visualize & present

Model data

Manage integrations

AI

Syntax

Properties

Examples

Getting started

Manage content

Analyze data

Deliver content

Visualize & present

Model data

Manage integrations

AI

​Syntax

​Properties

​Examples

Syntax

Properties

Examples