> 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.

# Show several measures or two axes in one dashboard chart

> Chart several measures or filtered counts as separate bars, or combine bars and a line on two axes, in a Mammoth dashboard chart's edit panel.
>
> Applies to: Roles: Anyone who can edit the dashboard. Where: Dashboard editor › click a chart › Multiple measures or Measures

A dashboard chart can show more than one number. **Multiple measures** turns a Bar chart's bars into separate measures or filtered counts; the **Measures** section mixes bars, lines and areas on up to 3 axes. Both are in a chart's edit panel in the dashboard editor (see [Set up a chart](https://mammoth.io/docs/learn/dashboards/edit-a-chart/)).

## Show several measures as separate bars

On a **Bar** or **Bar (H)** chart, switch on **Multiple measures** ("Show several measures or filtered counts as separate bars."). Each measure becomes one bar, so the bars are the measures themselves and there's no **By**. Use it for charts like "how many records are flagged A, B or C". A chart that already has several measures opens with the switch on.

Each row in **Measures** has:

| Control | What it does |
|---|---|
| Measure | **Count of records** (the default for a new row) or any number field. |
| **Aggregation** | **Sum**, **Average**, **Minimum**, **Maximum**, **Count**, **Distinct** or **Median**. |
| **Move up**, **Move down** | Change the bar order. |
| **×** | Removes the measure (when there's more than one). |
| **Label** | The bar's name. |
| **Conditions** | Count or sum only the rows that match. Click **+ Add condition**, then pick a field (**Choose a field**), an operator and a value. |

Condition operators:

| Operator | Value |
|---|---|
| **equals** | One **Value** |
| **is one of** | **Values (comma-separated)** |
| **is between** | **Min** and **Max** |

- For a text field, sample values show as chips you can click to fill in.
- A condition with no field or no value is ignored until you complete it.
- Click **+ Add measure** for another bar.
- **Chart conditions**, below the measures, apply the same kind of condition to the whole chart. They combine with each measure's own conditions: a row must match both.

Example: to compare open, overdue and closed tickets, add three measures, each **Count of records**. Label them Open, Overdue and Closed, and give each a condition on Status.


## Combine bars and a line on two axes

On **Bar**, **Bar (H)**, **Line**, **Area**, **Grouped bar** and **Combo** charts, the **Measures** section lists every measure on the chart. Each one can be drawn as bars, a line or an area, and placed on its own axis. Use it to show revenue as bars and margin % as a line on one chart.

Each measure row has:

| Control | What it does |
|---|---|
| Colour swatch | **Set series color** for this measure. **×** does **Reset to auto color**. |
| Measure | The field. |
| **Draw as** | **Bar**, **Line** or **Area**. |
| **Aggregation** | **Sum**, **Average**, **Minimum**, **Maximum**, **Count**, **Distinct** or **Median**. |
| Axis | **Axis 1**, **Axis 2** and so on. Pick **+ New axis** to give the measure its own scale. A chart can have up to 3 axes. |
| **×** | Removes the measure (when there's more than one). |

**+ Add measure** adds the next unused number column, drawn as a **Line**, on an axis that matches its unit.

- A second measure on a second axis turns the chart into a **Combo**.
- On a chart with more than one axis, each reference line and event in **Annotations** asks "Which axis this value belongs to".

Example: to plot revenue against margin:

1. Set the first measure to Revenue, drawn as **Bar** on **Axis 1**.
2. Click **+ Add measure** and choose Margin %.
3. Set **Draw as** to **Line** and the axis to **+ New axis**.


## Limits

| Item | Limit |
|---|---|
| Axes per chart | Up to 3 |

## Related

- [Set up a chart](https://mammoth.io/docs/learn/dashboards/edit-a-chart/): fields, Top N and the rest of the panel.
- [Add a target line, event or caption](https://mammoth.io/docs/learn/dashboards/chart-annotations/): reference lines and events per axis.
- [Dashboard chart types](https://mammoth.io/docs/learn/dashboards/chart-types/): Combo and other types.

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