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

# How to build a custom dashboard

> Create a dashboard from a template or from scratch, add SQL, funnel, retention and user paths charts, and share it with your team.

A dashboard puts the metrics that you check often on one page. Every member of the workspace can see it. This guide builds one from a template, then adds your own charts.

## Part 1: Create the dashboard

**1. Open Dashboards**

Click **Dashboards** in the left navigation.

**2. Choose a start**

Under **Templates**, click a template to preview it with live data from the last 30 days: **Channels and campaigns**, **Game KPIs** or **Game health**. Or, under **Start from scratch**, click **Blank dashboard**.

**3. Save**

For a template, click **Create board**. Nothing is saved before you click it.

**4. Name it**

Click the name or the description under it to edit it in place. Press **Enter** to save.

## Part 2: Add charts

Click **Add chart**. Pick an example, or click **Blank chart**.

| Goal | Chart type | Start from |
| - | - | - |
| One number, such as unique visitors | Number | **Unique visitors** example |
| A trend over time | Line, Area or Bar | **Traffic over time** example |
| A trend split by a value | Stacked bar, or Area with a **Breakdown column** | Your own SQL |
| A share of a total | Pie | **Traffic sources** example |
| A ranked list | Table | **Top landing pages** example |
| Conversion through steps | Funnel | **Signup funnel** example. See [the funnel guide](https://docs.manalens.dev/guides/funnels.md). |
| People who come back | Retention | **User retention** example. See [the retention guide](https://docs.manalens.dev/guides/retention.md). |
| Paths between pages and events | User paths | **User flow** example. See [the user paths guide](https://docs.manalens.dev/guides/user-paths.md). |

For a SQL chart, write a query on `raw_events` (or on `sessions` for session counts) and name the columns to draw: the **X column** and **Y column**, or the **Number column**. Use `{{date_from}}` and `{{date_to}}` so the chart follows the dashboard date range. Click **Save Chart**.

```sql theme={null}
SELECT toDate(original_timestamp) AS day, count() AS signups
FROM raw_events
WHERE type = 'track' AND event = 'signup_completed'
  AND toDate(original_timestamp) BETWEEN {{date_from}} AND {{date_to}}
GROUP BY day
ORDER BY day
```

> [!TIP]
>
> Set a **Number format** to show values well: `.1%` for a rate, `,.0f` for whole numbers, `$,.2f` for US dollars.

## Part 3: Organize and share

* Use the chart menu to edit, duplicate, move to another dashboard, or delete a chart.
* Give one chart its own date range with the date picker in its header. Click **Use dashboard range** to remove it.
* Click **Export CSV** on a chart to download its data.
* Open the dashboard menu (**•••**) and click **Duplicate dashboard** to make a copy to change.
* Send the page URL to a teammate. Viewers can see dashboards but cannot change them.

## Part 4: Build charts from an AI tool

Ask [Ask AI](https://docs.manalens.dev/guides/ask-ai.md) for a chart and click **Save to dashboard**. Or connect the [MCP server](https://docs.manalens.dev/mcp/overview.md) with the `dashboards:write` scope and ask your AI tool to create charts. See [Charts and dashboards](https://docs.manalens.dev/mcp/charts.md).

## Related

* [Dashboards](https://docs.manalens.dev/features/dashboards.md): chart kinds, SQL rules and templates.
* [How to query your data with SQL](https://docs.manalens.dev/guides/sql-explorer.md)
* [Roles](https://docs.manalens.dev/security/roles.md): who can create and edit dashboards.


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