Once you've filtered down to the right rows, sort and group control how those rows are presented. This article shows the controls and common patterns.
Sort
- Pick a field and a direction (ascending / descending).
- Add multiple sort keys — primary, secondary, tertiary — for tie-breaking.
- Sort on any field including custom and computed fields.
Group
- Pick one field to group by — rows with the same value cluster under a heading.
- Optionally show counts per group (“Customer A (12)”).
- Optionally show aggregates per group (sum, average, max, min).
- Groups can be collapsed by default to keep long lists scannable.
Sort and Group Combined
Sort within groups: groups are shown by group field, and rows inside each group are sorted by the chosen sort key.
Worked Examples
- Tickets by customer, newest first: Group by customer, sort by created_at desc within group.
- Sales by region: Group by region, show sum(amount) per group, sort groups by sum desc.
- Tasks by status: Group by status (Open, In Progress, Done), collapse Done by default.
- Inventory low-stock first: Sort by stock_level asc, secondary sort name asc for alphabetical tiebreak.
- Time-series log: Sort by timestamp desc, group by day, count per group.
Tip: Grouping can be expensive on very large datastores. If a group view feels slow, consider applying tighter filters first.