Skip to main content
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 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 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. 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.

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

Chart kinds

A chart is one of four kinds:

SQL charts

A SQL chart runs a query on raw_events, with the same rules and limits as the Explorer. 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 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.
You can also list your saved dashboards from an AI tool with the MCP server.