Skip to Content

Quick Start

Create your first metric

Chart one question from your data and save it to a dashboard.

The video creates a workspace from a new datasource, builds a metric from two fields and saves it to a new dashboard.

Before you start

Open the metric builder

  1. Go to Home and select your workspace.
  2. Select New metric.

You can also select Create metric on any dashboard. The builder opens as Untitled Metric with a Draft label.

Build it from fields

You pick the columns. No SQL needed.

  1. In the Schema list, open your table. To find a column, use Find a table or column.
  2. Double-click a text or date column, such as region. It goes to Dimensions: what you break the data down by.
  3. Double-click a number column, such as amount. It goes to Measures: what you add up.

You can also drag a column into Dimensions or Measures.

The builder runs the query and draws a chart. A measure starts as SUM. Select SUM to pick another one, such as COUNT or AVG.

Metric builder with the subscription_orders table open in Schema, plan under Dimensions, SUM of amount under Measures, and a bar chart of revenue for the Growth, Starter and Enterprise plans.
plan in Dimensions and amount in Measures give revenue by plan as a bar chart.

Use Chart, Table and Query to check the result. Use the chart type menu (it shows Bar for this example) to change the chart.

Or ask Bryn

  1. Select Bryn at the top right to open the panel.
  2. Type your question in plain words, for example Monthly revenue trend as a line chart, and press Enter.
  3. Bryn writes the SQL, runs it and shows the result. Select Apply chart to put it in the builder.

Bryn can only use the tables this workspace can read. For more, see Create a metric with Bryn.

Or write SQL

Select SQL above the schema list, write your query and select Run query. Then select Use results to chart it. See Create a metric using SQL.

Save it to a dashboard

  1. Select Save to dashboard. It turns on when the metric has a measure.
  2. Under Dashboard, pick a dashboard. If you have none, select New dashboard, enter a name such as Revenue overview, and select Create.
  3. Enter a Metric title, for example Revenue by region. Databrain fills in the Metric ID from the title.
  4. Select Save and add to dashboard.
Save to dashboard dialog with Revenue overview selected, Metric title Revenue by plan, Metric ID revenue_by_plan with a short suffix, an empty Metric description, Advanced options, and Cancel and Save and add to dashboard buttons.
Save to dashboard. The Metric ID fills in from the title.

The dashboard opens with your metric on it. Next, customize the dashboard.

If something goes wrong

  • Save to dashboard is greyed out. Add a measure first.
  • The Schema list is empty. The datasource has no tables yet. Open Data Studio > Datasources, open the datasource and select Sync now.
  • Bryn asks you to select a client. Pick a client, or All clients, under Preview at the top of the builder, then ask again.
  • Bryn says “Setup required”. Your company’s AI provider has no credit left. Ask an Admin to check Settings > LLMs.