default_group_by - Query views

Enables or disables a GROUP BY in the query view’s query. Automatically set to false if there are no measures in the query view.

This query view-level boolean parameter is distinct from the model-level default_group_by parameter, which controls implicit GROUP BY behavior for measure-less queries across the entire model. The two settings apply at different scopes.

Syntax

query:
  default_group_by: <true_or_false>

Properties

object[]

An object containing the individual parameters that make up a query view’s query definition.

Hide query properties

boolean

If true, the query will include a GROUP BY clause. If false, duplicate rows will not be grouped.Note: Omni automatically sets this to false if the query view does not contain any measures.

Examples

Group duplicate rows for users with the same name

query:
  fields:
    users.name: user_name
  default_group_by: true

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

default_group_by - Query views

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples