Show several measures or two axes in one dashboard chart
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).
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:
- Set the first measure to Revenue, drawn as Bar on Axis 1.
- Click + Add measure and choose Margin %.
- 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: fields, Top N and the rest of the panel.
- Add a target line, event or caption: reference lines and events per axis.
- Dashboard chart types: Combo and other types.
Something wrong? support@mammoth.io