Group a number column into ranges on a dashboard chart
Anyone who can edit the dashboard · Updated 8 Nov 2026
A calculated dimension cuts a number column into named ranges, such as a "Spend band" of 0–100, 100–500 and 500+. You can then use it as a category in By. In the dashboard editor, click a chart to open its edit panel; anyone who can edit the dashboard can add one.
Create a calculated dimension
- In the Data section, under the field pickers, click Create calculated dimension. It appears when the chart has a By field and the dataset has a number field.
- Fill in the dialog (table below).
- Click Create. It stays disabled until there's a name, a source measure and a label on every band.
| Field | What it does |
|---|---|
| Name | The dimension's name, for example "Spend band". |
| Source measure | The number column to cut. |
| Bands | One row per range: a Label, a Min and a Max. Add band adds a row and × removes one. |
| Uncovered rows | With Show as ticked (the default), rows outside every band are grouped under a name, Other by default. Untick it and those rows are Excluded. |
How bands work
- Each band includes its Min and excludes its Max, so 100 falls in 100–500, not 0–100.
- Leave Min or Max empty for no lower or upper limit.
- Bands keep the order you entered them in.
Where the new dimension appears
The new dimension is saved to the dashboard, not only this chart. It appears in every chart's By list under Calculated. Readers can't open the rows or drill into a band. You can't edit or remove a calculated dimension from this panel after you create it, so check the bands before you click Create.
Limits
| Item | Limit |
|---|---|
| Calculated dimensions | Can't be edited or removed from the panel after you create them |
Related
- Set up a chart: the By field and the rest of the panel.
- What readers can do with a chart: drill-down and rows (not on bands).
- Dashboard chart types: charts that take a category.
Was this page helpful?
Something wrong? support@mammoth.io