Skip to main content

group by

To organize rows in a table or dataset into groups according to the values they share in one or more selected columns or fields.

In plain English

This puts rows with the same value together so they appear as a set. It does that using one or more chosen columns or fields.

In context

Here, "group by" names the action for arranging the table's rows into groups based on matching values in selected columns or fields.

Situation
Using dashboards, tables, filters, sorting, views, and bulk controls
What it communicates
offers a row-grouping action in the table toolbar

Meaning limits

The term itself does not specify which columns or fields are available for grouping or how the grouped rows are displayed.

Examples

“The clerk grouped the attendance rows by class and homeroom instead of alphabetizing the whole sheet.”

Core meaning

“For the morning review, the team chose to group by status rather than by owner.”

In context