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

# Dashboards

> Build custom dashboards with SQL charts (number, line, area, bar, stacked bar, pie, table) and funnel, retention and user path charts, or start from a template.

**Dashboards** hold the charts you want to check often. Each project can have many dashboards, and every member of the workspace can see them.

## Create a dashboard

1. Open **Dashboards** in the left navigation.
2. Under **Templates**, click a template. Or, under **Start from scratch**, click **Blank dashboard**.

When you click a template, a preview opens. It shows the template charts with live data from your project for the last 30 days. Click **Create board** to save it, or **Cancel** to go back. Nothing is saved until you click **Create board**.

### Templates

| Template | Charts |
| - | - |
| **Channels and campaigns** | Sessions, paid share, campaign share, sessions by channel, a channel table and a UTM campaign table (visitors, sessions, bounce rate, pages per session, revenue). Traffic trends, pages and sources are on [Overview](https://docs.manalens.dev/features/overview.md). |
| **Game KPIs** | D1, D7 and D30 retention, DAU, MAU, stickiness (DAU / MAU), sessions per DAU, session length, ARPDAU, ARPPU, daily active players, install cohorts, a level funnel (levels 1 to 4), a levels table (players, starts, completes, fails, fail rate) and currency sources and sinks. See [Game metrics](https://docs.manalens.dev/data/metrics.md#game). |
| **Game health** | Crash-free sessions, crash-free players, errored sessions, errors per session, errors per session by build, top errors. See [Errors and crashes](https://docs.manalens.dev/features/error-tracking.md). |

Template charts are SQL charts. You can open any of them with **Edit chart** to see or change the query. The sessions, bounce rate and session revenue charts read the `sessions` table: one row for each [session](https://docs.manalens.dev/data/metrics.md#sessions) of the date range, the same sessions as on **Overview**. The bounce rate and pages per session are for sessions with a page view. **Channels and campaigns** credits each session to the channel and UTM fields of its first page view, and its revenue is the `revenue` property of events in that session. The game templates count game sessions (one run of the game), which are another unit. For conversions that happen days later, use [Attribution](https://docs.manalens.dev/attribution/overview.md). A chart that reads `sessions` or `session_events` can stop with a memory error when the date range has more than about 200,000 page views and custom events; see the [SQL limits](https://docs.manalens.dev/features/explorer.md#limits).

## Add a chart

1. Open a dashboard and click **Add chart**.
2. Pick an example, or click **Blank chart**. Type in the search box to find an example by its name or description.
3. Check the **Chart title** and **Chart type**. Optionally add a **Description** (up to 255 characters); it shows under the title on the chart card.
4. For a SQL chart, write the **SQL query** and name the result columns to draw. For a funnel, retention or user paths chart, set its steps and settings.
5. Click **Add chart**.

### Chart examples

| Group | Examples |
| - | - |
| **Acquisition** | Traffic sources, top landing pages, traffic over time |
| **Behavior** | Unique visitors, average session duration, bounce rate, daily event volume, events by type, user flow, user retention |
| **Conversion** | Signup funnel (home page to `signup_completed`), revenue |

### Chart kinds

A chart is one of four kinds:

| Kind | Chart types |
| - | - |
| **SQL** | Number, Bar, Stacked bar, Line, Area, Pie, Table |
| [Funnel](https://docs.manalens.dev/features/funnels.md) | Funnel |
| [Retention](https://docs.manalens.dev/features/retention.md) | Retention |
| [User paths](https://docs.manalens.dev/features/user-paths.md) | User paths |

### SQL charts

A SQL chart runs a query on `raw_events`, with the same rules and limits as the [Explorer](https://docs.manalens.dev/features/explorer.md). Use `{{date_from}}` and `{{date_to}}` in the query: they take the dashboard range or the chart range. Put any filter in the `WHERE` clause.

The chart draws columns of the query result:

* **Number**: the **Number column** of the first row, or the first numeric column when you do not name one. The query must return one row.
* **Table**: every result column, in query order.
* **Bar**, **Line**, **Area**: the **X column** (a category or a day) and the **Y column** (the value).
* **Pie**: the **Slice column** and the **Y column**.
* **Stacked bar**, and **Area** with a **Breakdown column**: one series for each value of the breakdown column, stacked. Return the largest values and put the rest in **Other** in your query. **Other** is drawn in gray, and each value keeps its color on every chart. Comparison with the previous period is not shown on these charts.

A **Number format** (a [d3-format](https://d3js.org/d3-format) specifier) changes how values show: `.1%` shows 0.256 as 25.6%, `,.0f` shows whole numbers, `$,.2f` shows US dollars. Without a format, numbers show with thousands separators.

When you save a SQL chart, the query runs once for the last 30 days. If a column you named is not in the result, or a number query does not return one row, the chart is not saved and the editor shows the reason.

### How a chart is stored

Each chart is stored as a title, an optional description and one chart spec: `{ version, query, view }`.

* `query` says what the chart computes: SQL, a funnel (its steps and settings), retention or user paths (their settings).
* `view` says how the chart is drawn: a number card (`text`), a table (`x-table`), a pie (`arc`), a bar, line or area chart, or the funnel, retention or user paths drawing (`x-funnel`, `x-retention`, `x-sankey`). A stacked bar is a bar with a breakdown column.

## Date range and comparison

Chart data follows the dashboard date range in the top bar. The filters in the top bar apply to funnel, retention and user paths charts; a SQL chart has its filters in its query. Turn on comparison to show the previous period next to the current one.

### Chart date range

Each chart has its own date picker in its header. It shows the dashboard range until you change it. Click a start day and an end day in the calendar, then click **Apply** to give that chart its own range. **Cancel** closes the calendar without a change. The other charts keep the dashboard range. A chart with its own range has a highlighted date picker; click **Use dashboard range** to remove the override.

When you change the dashboard date range in the top bar, every chart takes the new range again. A chart range is not saved with the chart: it is kept in the page URL, so a reload or a shared link shows the same ranges. With comparison on, each chart compares with the period before its own range.

## Name and description

Click the dashboard name or the description under it to edit it in place. Press **Enter** or click away to save. Press **Escape** to cancel. A description can have up to 500 characters; clear the text to remove it. Viewers see the name and description but cannot edit them.

## Duplicate a dashboard

Open the dashboard menu (**•••**) and click **Duplicate dashboard**. The copy is named `<name> - Copy` and has the same description and charts, in the same order, with their settings. The copy opens when it is ready. The original does not change.

## Edit or remove

Use the chart menu to edit, duplicate, move or delete a chart. Click **Export CSV** to download the chart's data for the current date range, with every column the query or report returns. Use the dashboard menu to duplicate or delete the dashboard.

> [!TIP]
>
> You can also list your saved dashboards from an AI tool with the [MCP server](https://docs.manalens.dev/mcp/overview.md).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.