> For the complete documentation index, see [llms.txt](https://docs.toucanai.cloud/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.toucanai.cloud/build/charts/chart-types/table.md).

# Table

{% hint style="info" %}
**Target Audience**: Non-technical users and builders configuring charts in the Library.
{% endhint %}

<figure><img src="/files/xPiS3iOKCy5pmQbi2RAz" alt="Table chart example"><figcaption></figcaption></figure>

## Overview

A **table** lists query **rows and columns** in the Library or embeds. You choose which columns to show, how headers and values are formatted, and table behavior (pagination, totals, row styling).

Unlike bar or line charts, there is no separate dimension/measure mapping — configuration is per **column** and per **table** settings.

In the **Library**, enable **Manual Edit**, set **Type** to **Table**, and select **Data**. One block appears per query column under **Display columns**.

Shared fields (**Title**, **Narrative**, **Data**) are in [Chart types](/build/charts/chart-types.md#shared-chart-level-settings).

## When to use it

**Good fit**

* Detailed listings (employees, orders, transactions).
* Exact values where charts would hide precision.
* Paginated logs or directories on a dashboard.

**Prefer another chart**

* Trends or comparisons → [Line chart](/build/charts/chart-types/line-chart.md) or [Bar chart](/build/charts/chart-types/bar-chart.md).
* Two-dimensional intensity grid → [Heatmap chart](/build/charts/chart-types/heatmap-chart.md).
* Single KPI → [Value](/build/charts/chart-types/value.md).

**Examples:** employee directory with formatted dates, product catalog with tag-style status, paginated transaction log.

**Common setups**

* **Listing:** show/hide columns (eye icon), set **Label** and formats, set **Rows per page**.
* **Status tags:** **Style** → **Tag** on a text column.
* **Footer totals:** **Show totals in last row** under *More table options*.

## Configuration options

Open the chart in the **Library**, turn on **Manual Edit**, select **Data**, then set **Type** to **Table**. The column list updates when the query changes.

Prerequisites: [connected database](/build/data-connections/how-to/add-a-database.md), Manual Edit ([how-to](/build/charts/how-to/customize-a-chart-manually.md)).

### Column

| Option              | How it works                                                                                     |
| ------------------- | ------------------------------------------------------------------------------------------------ |
| **Display columns** | One row per query column. **Eye** icon: show or hide in the table.                               |
| **Label**           | Header text (expand column accordion).                                                           |
| **Style**           | **Tag** for tag-style cell rendering.                                                            |
| **Format date**     | On date columns. Preset date display.                                                            |
| **Format number**   | On numeric columns. Standard, Percent, Currency (with **Currency display**), decimals, **Unit**. |

### Table

| Option                      | How it works                                                    |
| --------------------------- | --------------------------------------------------------------- |
| **Rows per page**           | Rows per page, **1–150** (default **5**).                       |
| **Show totals in last row** | *More table options.* Totals for numeric columns in the footer. |
| **Alternate row color**     | *More table options.* Alternating row backgrounds.              |

The AI assistant can propose visible columns and formatting; use **Manual Edit** to refine.

**Suggested next steps:** [Chart types](/build/charts/chart-types.md) · [Customize a chart manually](/build/charts/how-to/customize-a-chart-manually.md) · [Create a chart with AI](/build/charts/how-to/create-a-chart-with-ai.md)