Grouping records

Grouping records in NocoDB helps you organize data by categories using Groups and Subgroups. You can group records by up to three levels, making it easier to analyze and navigate complex datasets.

Add or edit groups

1. Click Group By in the toolbar.
2. Select the field to group records by.
3. (Optional) Sort the groups in ascending or descending order.
4. (Optional) Use + New Subgroup to create a subgroup within the selected group.

Enable or disable a group

You can switch a grouping off without removing it, then turn it back on later with the same settings intact.

1. Click Group By in the toolbar.
2. Use the checkbox next to a group to enable or disable it.

A disabled grouping keeps its field and sort configuration, so it is handy for temporarily flattening the view or comparing grouped and ungrouped layouts without rebuilding the setup.

Delete groups

1. Click Group By in the toolbar.
2. Click the 🗑 icon next to the group you want to remove.

Group level field aggregations

You can perform aggregations on fields at each group level. This allows you to summarize data within each group, such as calculating totals or averages.