Skip to content
Learn › Build dashboards: open the docs menu

Set up a dashboard chart: measure, category and top 10

Anyone who can edit the dashboard · Updated 8 Nov 2026

Every chart on a Mammoth dashboard can be edited by hand as well as through the AI chat. In the dashboard editor, click a chart and its edit panel opens beside the canvas. Anyone who can edit the dashboard can change its charts, and every change redraws the chart straight from your data: no AI is involved in the field and style controls.

Open a chart's edit panel

Click the chart on the canvas, or hover over it and click Edit in its toolbar. The panel docks on the right, so the canvas is your live preview. Its title is the chart's title, with the chart type under it.

The panel is one scrolling column. Only the sections that apply to the chart type appear:

  1. The chart type, with Also works as and See more. See Switch a chart to another chart type.
  2. Multiple measures (Bar and Bar (H) only) and 3. Measures (charts that can mix bars, lines and areas). See Several measures or two axes.
  3. Title.
  4. Data: the field pickers and Create calculated dimension (see Group a number column into ranges).
  5. Annotations.
  6. Options for this chart type, under Data, Style, Labels, Axes and Annotations. See Chart options.
  7. Readers can (edit panel only, not the studio). See What readers can do with a chart.
  8. Add a caption.

The same controls appear in the studio when you first add a chart. Ask AI in the panel header ("Ask AI about this") closes the panel and puts the cursor in the AI chat with this chart selected. See Ask the AI about one chart or block.

Dashboard editor with a bar chart selected: the edit panel on the right shows Also works as, Multiple measures, Measures, Title and Data, and the chat is scoped to the chart

Save or discard your chart changes

Closing the panel with changes asks Save your changes?: "Save the changes you made in this panel, or discard them and restore how things looked when you opened it."

ButtonWhat it does
Keep editingReturns to the panel.
DiscardPuts the chart back as it was when you opened the panel, including its caption.
Save changesKeeps your edits.

Rename a chart with the Title field

Type in Title to rename the chart. A title you type stays when you later change the measure, the By field or the chart type. An automatic title updates to match the fields.

Choose the chart's fields: Measure, By, Split by and Show

Each row in the Data section is a dropdown of the dataset's fields. Only the rows the chart type uses appear.

FieldWhat it does
MeasureThe number to chart. Count of records counts rows. An empty measure reads Choose a measure….
X, YReplace Measure on Scatter and Bubble charts. And is a second measure on charts that take two.
ByThe category to break the measure down by. A date field under Over time makes a time axis; a calculated dimension sits under Calculated. KPI, Big number, Icon stat, Gauge and Histogram have no By.
Rows, ColumnsThe two categories of a Heatmap, Sankey, Sunburst or Network.
Split byA second category that splits each bar or area. Only on Stacked bar, 100% stacked, Stacked area and Marimekko.
AggregateSum, Average, Minimum, Maximum, Count, Distinct or Median. On charts with a Measures section, each measure has its own aggregation instead.
ShowHow many categories: All, Top 5, Top 8, Top 10, Top 15, Top 20 or Custom… (any number up to 200).

Show only the top 10 categories in a chart

Use Show with Sort. To show revenue for the top 5 regions:

  1. Set Measure to Revenue and Aggregate to Sum.
  2. Set By to Region.
  3. Set Show to Top 5.
OptionChoicesWhat it does
SortHigh → low (default), Low → high, A → Z, Z → AThe order of the categories. It also decides which rows a Top N keeps.
Display asBy rank (default), A → Z, Z → AShows the kept rows in another order, for example the top 5 by revenue displayed A to Z.

Both sit in the Data group and are hidden when By is a date.

Why Mammoth won't draw a forecast chart

Charts show what's in your data; they don't project it forward. If you describe a forecast in the Add a chart describe box ("project next year's revenue"), Mammoth doesn't draw an invented line. The studio explains why and previews the closest chart your data can show, with a button such as "Add a Bar instead". Add that chart, or describe another. To draw a chart the library doesn't have, see Custom charts.

Troubleshooting chart field messages

MessageWhat it means
"Choose a field for By to draw this chart."You can't add the chart until By is set.
"Loading this dataset's fields…"The field list is still loading.
"Couldn't load this dataset's fields. Reopen the panel to try again."Close the panel and open it again.
"No measure resolved for this chart yet — try another type, or reload the dashboard."Try another chart type, or reload the dashboard.
"Couldn't build a preview. Try a different chart or description."Pick another chart type or change the description.
"No data matches the current filters."The filters leave no rows. Change or clear them.
Was this page helpful?

Something wrong? support@mammoth.io