groups

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>

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

groups

array

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

Hide groups properties

filter

object

required

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

name

string

required

The name to assign to values matching the filter condition.

else

string

The fallback group name for values that don’t match any filter condition.

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

group_label

hidden

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

Limitations

Syntax

Properties

Examples

​Limitations

​Syntax

​Properties

​Examples

Limitations

Syntax

Properties

Examples