> ## Documentation Index
> Fetch the complete documentation index at: https://docs.adriel.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Reading & interpreting tables

> Column sort, in-cell indicators, conditional formatting, column widths, and the Others row for full-size table widgets.

Both the [Ads Table](/widgets/widget-library/table-widgets/ads-table) and [Generic Table](/widgets/widget-library/table-widgets/generic-table) share the same column-level and layout behavior. This article covers the elements that appear in a full-size table widget and what each one means.

The [Small table](/widgets/widget-library/table-widgets/small-table) works differently — see its article.

## Metric column controls

Hover on a column header — a small dropdown icon appears. The options in the menu depend on the column type.

### Numeric columns

For metric columns that hold numbers (Spend, Clicks, CTR, ROAS, and so on), the dropdown has five options:

* **Sort ascending** — smallest to largest.
* **Sort descending** — largest to smallest.
* **Display as a column graph** — toggle the inline horizontal indicator inside the cell. See [Column graph indicator](#column-graph-indicator) below.
* **Conditional formatting** — apply Excel-style coloring rules to the column. See [Conditional formatting](#conditional-formatting).
* **Remove** — remove the column from the widget.

### String columns

For text columns like Campaign name or Ad name, the dropdown has three options:

* **Sort ascending**.
* **Sort descending**.
* **Remove**.

Column graph and conditional formatting only apply to numeric columns and aren't shown for string columns.

Sort is per-widget and persists with the dashboard.

## Column graph indicator

<Note>
  The "column graph" referenced here is an inline indicator drawn inside each cell of a table column — not the [Column chart](/widgets/widget-library/chart-widgets/column-chart) widget, which is a separate chart type.
</Note>

Selected numeric columns render a horizontal bar behind the value in each cell. The bar length is proportional to the row's value versus the largest visible value for that column, so standout rows are easy to spot.

Toggle **Display as a column graph** from the column dropdown.

## Conditional formatting

**Conditional formatting** applies Excel-style coloring rules to a numeric column. Open it from the column dropdown → **Conditional formatting**.

Two modes:

### Single color

Color cells that meet a condition.

* **Apply to** — the column the rule applies to (defaults to the column the dropdown was opened from, for example, CPC).
* **Condition** — a comparison operator (for example, `>`) and a value (for example, `600`).
* **Target** — where the color is applied:
  * **Background color** — fills the cell background.
  * **Text color** — colors the cell's number.
  * **Background + Text color** — both at once.
* **Color** — the color for the selected target(s).

For example, apply to CPC, condition `> 600`, Target Background color, red — every CPC cell above 600 renders with a red background.

### Color scale

Color cells on a gradient from a low anchor to a high anchor.

* **Apply to** — the column the rule applies to.
* **Target** — where the gradient is applied: **Background color**, **Text color**, or **Background + Text color**.
* **Minpoint** — the low anchor. Pick **Number** and enter a value; assign a color.
* **Midpoint** — an optional middle anchor. Set to **None** to skip, or **Number** with a value and color.
* **Maxpoint** — the high anchor. Pick **Number** and enter a value; assign a color.

Cells render on a gradient between the anchors. Cells outside the range clamp to the nearest anchor's color.

To clear a rule, open Conditional formatting again and click **Clear formatting**.

<Note>
  Conditional formatting is user-defined coloring. It's different from the Ads Table's [Setting targets](/widgets/widget-library/table-widgets/ads-table#setting-targets), which uses blue/red based on metric directionality.
</Note>

Conditional formatting renders on transposed tables (Switch rows/columns enabled) the same way it does on normal tables.

In Shareable Views and Snapshots, the Conditional formatting controls are hidden so viewers can't change the rules — but the rules themselves still render.

## Column widths

Two ways to resize columns:

### Drag a single column

Drag the vertical divider between two column headers to resize that column freely. Or double-click the right edge of a column header to fit that one column to its longest visible value (including the header text).

### Reset all columns at once

At the bottom-right of the widget, two buttons are always visible:

* **Fit all columns to content** — every column resizes to fit the widest visible value in that column.
* **Make all columns same width** — every column is set to the same width, regardless of content.

Both apply to metric and breakdown columns. Column widths persist when the dashboard is saved.

## Others row

If a widget has a row limit (from a filter, a breakdown cap, or the widget's default limit), rows beyond the limit are grouped into an **Others** row so the visible totals still reconcile against the widget's total.

## Save behavior

Sort selections, dropdown toggles, conditional-formatting rules, and column widths save automatically when the dropdown closes or when Conditional formatting is applied. Persist changes to the dashboard by clicking **Save dashboard** — otherwise the changes revert when the dashboard reloads.

## Related

For refresh cadences and time-zone behavior across sources, see [Time zones & data freshness](/data-sources/how-data-works/time-zones-and-data-freshness).

## Next steps

<CardGroup cols={2}>
  <Card title="Ads Table" href="/widgets/widget-library/table-widgets/ads-table">
    Row hierarchy, Show total row + Source aggregations, targets, and Status.
  </Card>

  <Card title="Generic Table" href="/widgets/widget-library/table-widgets/generic-table">
    Non-advertising data sources with Totals.
  </Card>

  <Card title="Small table" href="/widgets/widget-library/table-widgets/small-table">
    Lightweight single-breakdown, single-metric widget.
  </Card>

  <Card title="Breakdowns" href="/widgets/breakdowns-and-metrics/breakdowns">
    How breakdowns work in general.
  </Card>
</CardGroup>
