groups - Dimensions

This parameter generates CASE WHEN... SQL statements in the background.

Limitations

This parameter is only compatible with string fields. Use bin_boundaries for numeric fields.

Syntax

<dimension_name>:
  sql: ${<view_name>.<field_name>}
  groups:
    - filter:
        is: [<value_1>, <value_2>, ...]
      name: <group_name>
  else: <fallback_group_name>
  else_raw_value: <boolean>

Properties

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

array

An array of group definitions that map field values to group names.

Hide groups properties

object

required

A filter condition using the is: syntax to match values.

string

required

The name to assign to values matching the filter condition.

string

The fallback group name for values that don’t match any filter condition. Not compatible with else_raw_value set at the same time.

boolean

When true, values that don’t match any filter condition keep their original value instead of falling back to else. Not compatible with else set at the same time.

Behavior

By default, values that don’t match any group fall back to the else label (for example, Other). Setting else_raw_value: true allows unmatched values to keep their original value instead of being replaced by a label. Groups using else_raw_value also behave differently, namely:

They sort by value instead of by declaration order.
Filter suggestions for the field are queried live instead of listing the declared group names.

else and else_raw_value can’t both be set on the same groups definition.

Examples

Status grouping

status_groups:
  sql: ${order_items.status}
  groups:
    - filter:
        is: [Cancelled, Returned]
      name: Test
    - filter:
        is: [Processing, Shipped]
      name: going
  else: Other
  label: Status Groups

Keep original value for unmatched states

region:
  sql: ${users.state}
  groups:
    - name: West
      filter:
        is: [CA, OR, WA]
  else_raw_value: true

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

groups - Dimensions

Limitations

Syntax

Properties

Behavior

Examples

​Limitations

​Syntax

​Properties

​Behavior

​Examples

Limitations

Syntax

Properties

Behavior

Examples