group-by

Organizes the rows returned from a query into groups. Within each group, you can apply an aggregate function, such as count() or sum() to get the number of items or sum, respectively.

group-by takes this syntax.

In this example, the query counts the number of rows for each Category field and groups the counts by category.

To return grouped null values in your queries, you must select the preference to include null values in Setup. Otherwise, queries ignore null values.

1. In Setup, enter Analytics in the Quick Find box.
2. Select Settings from the list of Analytics options.
3. In Settings, click the checkbox for Include null values in Analytics queries.

Here’s an example of a query that returns null values. It orders the results by the Sub_Category field and specifies that the results display in ascending order, with nulls first.

In this example, the query counts all of the rows and returns the number of different industries that you have opportunities with.

See Also

• Aggregate Functions
• Null Operators
• cogroup
• Use Group and Filter Pre-projection