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

# Read a number Explore Card: ranges, statistics, outliers

> Read a Mammoth number Explore Card: the histogram, Sum, Min, St.Dev, Average and Max, how range size is picked, distribution shapes, and how to find outliers.
>
> Applies to: Roles: The transformation shortcuts need edit access to the View. Where: View › Explore › Add card › a number column

A number card shows a vertical bar chart. Each bar is a range of values, and its height shows how many rows fall in it; five statistics sit below. Add one with **Add card** in the Explore panel; the shortcuts that change values need edit access to the View.

![Numeric Explore Card for quantity with a column chart, the chart type and Count menus and the Sum, Min, St.Dev, Average and Max statistics](https://mammoth.io/docs/images/20261009_194011_NumericExploreCard.webp)

## What a number card shows

- **Range labels** sit below each bar, for example "100 to 200". **Blank values** appear as a `(blank)` entry.
- **Hover a bar** for its exact range, its count and its share of the rows, with the hint "Click to select · drag across for a range".
- **Columns** (default) shows the shape; **List** shows the same ranges as rows, for reading exact counts. In list view, **Sort by** sorts by the card's measure or by the values in numeric order.

![Two numeric cards side by side, quantity and sales, each with a column chart and Sum, Min, St.Dev, Average and Max statistics](https://mammoth.io/docs/images/20261009_194203_NumericCardsSideBySide.webp)

| Statistic | What it tells you |
| --- | --- |
| **Sum** | Total of all values, useful for revenue, quantities and weights |
| **Average** | Arithmetic mean, your typical value |
| **Min** | Smallest value |
| **Max** | Largest value |
| **St.Dev** | Standard deviation: high means a wide spread, low means consistent values |

![Numeric card statistics: Sum 25.6k, Min -492, Max 499, Average 251, St.Dev 156.6](https://mammoth.io/docs/images/20260408_140937_Date_card19.webp)

![quantity card in list view with the Sort by menu open, showing a Count dropdown, a Descending dropdown, and Cancel and Apply buttons](https://mammoth.io/docs/images/20261009_194034_NumericCardListSort.webp)

![quantity card with the bar for value 2 hovered, and a tooltip reading Count: 3, 25%, with the hint Click to select, drag across for a range](https://mammoth.io/docs/images/20261009_194131_NumericCardBarTooltip.webp)

## How Mammoth picks the range size (granularity)

Mammoth picks the bar width for you, so you don't configure bins. The width is always a power of ten, one power below the order of magnitude of the column's range (max − min). A column where every value is the same gets 0.1-wide buckets, and ranges under about 1 get finer buckets still.

| Approximate data range | Auto bucket width | Example ranges | Typical use |
| --- | --- | --- | --- |
| ~1–3 | 0.1 | 0.0–0.1, 0.1–0.2 | Percentages, yield rates, ratios |
| ~3–32 | 1 | 0–1, 1–2, 2–3 | Small whole-number counts |
| ~32–316 | 10 | 0–10, 10–20, 20–30 | Ages, temperatures, small counts |
| ~316–3,162 | 100 | 0–100, 100–200 | Sales amounts, order quantities |
| ~3,162–31,623 | 1,000 | 0–1k, 1k–2k | Monthly revenue, transaction volumes |
| ~31,623–316,228 | 10,000 | 0–10k, 10k–20k | Annual revenue, enterprise metrics |
| ~316,228–3,162,277 | 100,000 | 0–100k, 100k–200k | Large aggregate totals |

Each tenfold increase in range gives a tenfold wider bucket. The transition points are approximate because Mammoth rounds to the nearest power of ten. When a filter narrows the range, the width is recalculated for the remaining rows.

To override it, open the aggregation menu, change **Granularity** to a finer or coarser power of ten (for example from 10 to 100), and click **Apply**.

![price card Count menu open, with Show values by COUNT, a Granularity dropdown set to 1,000,000, and Apply and Cancel buttons](https://mammoth.io/docs/images/20260408_142356_Countdropdownpanel1.webp)

![quantity card with one bar selected and the More options menu open, listing Replace, Remove and Keep all values like this, Add to dashboard, Copy values to clipboard, Export list as CSV and Export Image as PNG](https://mammoth.io/docs/images/20261009_193931_NumericCardMoreOptions.webp)

## Distribution shapes to recognize

| Shape | What you see | What it suggests |
| --- | --- | --- |
| Normal | Tallest bars in the middle, tapering to the edges. Common in salaries, product weights and measurements | An abrupt drop at an edge may mean missing data |
| Skewed | Values pile up at one end with a long tail. Common in transaction amounts and response times | The tail is worth a look |
| Bimodal | Two clusters with a gap, such as SMB and Enterprise deal sizes, or day and night shift temperatures | Usually two segments to analyze separately |

![Three numeric cards side by side (Sodium, Carbohydrates, Dietary Fiber), each with a histogram and statistics](https://mammoth.io/docs/images/20260408_143421_Threeside-by-sidecharts.webp)

![transaction_amount histogram with two clusters of bars: a tall one at the low end and a smaller one at higher values](https://mammoth.io/docs/images/20260408_142512_Bimodalhistogram1.webp)

## Find outliers and placeholder values in a number column

The card shows every value, including negatives, and doesn't flag any as invalid: whether a value is out of range is your business judgment. Look for:

- **An isolated bar** far from the rest, such as one bar at $10,000 when prices sit between $10 and $100.
- **Values outside the expected range**, such as negative prices or quantities, ages above 120, or percentages above 100.
- **A spike at one value** such as 0, 999 or -1, which often means a system default used in place of real data.

Hover the bar to confirm the count, then click it and use **Filter** to see those rows before you decide to remove them.

**Worked example:** temperature readings cluster around 22°C, with one bar at 150–160°C. Hovering shows COUNT: 3. Filtering shows all three come from one batch, from a faulty sensor. A Conditional Filter task now flags readings above 50°C.

![price histogram with most values in the middle bins and one isolated bar at the far right, 9,800](https://mammoth.io/docs/images/20260408_142537_Histogramshowingmaindistribution_with_one_islolated1.webp)

![temperature_celsius histogram with most values in the 20 to 30 bin; the tooltip reads COUNT 193](https://mammoth.io/docs/images/20260408_142454_Temperaturehistogramshowingnormaldistribution1.webp)

## Troubleshooting number cards

| Symptom | Cause | Fix |
| --- | --- | --- |
| Number statistics don't change after filtering | The value was selected but not filtered | Click **Filter** or double-click; check the filter badge |
| Too many bars | The range is wide for the granularity | Raise **Granularity** (for example from 10 to 100). A very high bar count can itself signal a quality problem |
| Chart jumps to a coarser granularity | Automatic granularity follows the rows currently counted, so a filter can change it | Set the granularity you want and click **Apply** |
| Number statistics look wrong | Numbers stored as text, or hidden characters or currency symbols | Check the column type and the raw values in the grid. See [Column types](https://mammoth.io/docs/learn/clean-and-shape/column-types/) |

## Related

- [Text, number and date cards](https://mammoth.io/docs/learn/explore/card-types/): Show values by, sorting and the More options menu.
- [Label rows and insert values](https://mammoth.io/docs/learn/clean-and-shape/label-and-insert/): the task **Replace all values like this** opens on a number card.
- [Filter rows](https://mammoth.io/docs/learn/clean-and-shape/filter-rows/): remove or flag outlier rows for good.

---
Source: https://mammoth.io/docs/learn/explore/number-cards.md · Updated: 2026-11-08