> AI agents: this is one page from Mammoth Analytics documentation. The index of all pages as Markdown is https://mammoth.io/docs/llms.txt. Append `.md` to any docs URL, or send `Accept: text/markdown`, to get Markdown.

# Group a number column into ranges on a dashboard chart

> Create a calculated dimension in a Mammoth dashboard chart to cut a number column into named ranges, such as spend bands, and chart by them.
>
> Applies to: Roles: Anyone who can edit the dashboard. Where: Dashboard editor › click a chart › Data › Create calculated dimension

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

1. 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.
2. Fill in the dialog (table below).
3. 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](https://mammoth.io/docs/learn/dashboards/edit-a-chart/): the **By** field and the rest of the panel.
- [What readers can do with a chart](https://mammoth.io/docs/learn/dashboards/chart-reader-actions/): drill-down and rows (not on bands).
- [Dashboard chart types](https://mammoth.io/docs/learn/dashboards/chart-types/): charts that take a category.

---
Source: https://mammoth.io/docs/learn/dashboards/calculated-dimension.md · Updated: 2026-11-08