Skip to main content
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

​
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