Skip to main content

Create Dashboards

In Rill, your dashboards are defined by metric definitions. Metric definitions are composed of:

  • A model - A data model creating a One Big Table that will power the dashboard.
  • A timeseries - A column from your model that will underlie x-axis data in the line charts. Time will be truncated into different time periods.
  • Measures - Numerical aggregates of columns from your data model shown on the y-axis of the line charts and the "big number" summaries.
  • Dimensions - Categorical columns from your data model whose values are shown in leaderboards and allows you to look at segments or attributes of your data (and filter / slice accordingly).
Dashboard Properties

For more details about available configurations and properties, check our Dashboard YAML reference page.

Creating valid metrics


Your timeseries must be a column from your data model of type TIMESTAMP, TIME, or DATE. If your source has a date in a different format, you can apply time functions to transform these fields into valid timeseries types.


Measures are numeric aggregates of columns from your data model. A measure must be defined with DuckDB SQL aggregation functions and expressions on columns from your data model. The following operators and functions are allowed in measure expressions:

  • Any DuckDB SQL numeric operators and functions
  • Filtered aggregates can be used to filter set of rows fed to the aggregate functions

As an example, if you have a table of sales events with the sales price and customer id, you could calculate the following metrics with these aggregates and expressions:

  • Number of sales: COUNT(*)
  • Total revenue: SUM(sales_price)
  • Revenue per customer: CAST(SUM(sales_price) AS FLOAT)/CAST(COUNT(DISTINCT customer_id) AS FLOAT)
  • Number of orders with order value more than $100 : count(*) FILTER (WHERE order_val > 100)

You can also add labels, descriptions, and your choice of number formatting to customize how they are shown in the dashboard.


Dimensions are used for exploring segments and filtering the dashboard. Valid dimensions can be any type and are selected using the drop down menu. You can also add labels and descriptions to your dimensions to customize how they are shown in the dashboard.

Updating dashboards

Using the UI / code

When you add a metrics definition using the UI, a code definition will automatically be created as a YAML file in your Rill project within the dashboards directory by default. However, you can also create metrics definitions more directly by creating the artifact.

In your Rill project directory, after the dashboard_name.yaml file is created in the dashboards directory, its configuration or definition can be updated as needed by updating the YAML file directly, using the following template as an example:

type: metrics_view
model: model_name
title: Dashboard name
default_time_range: ""
smallest_time_grain: ""
timeseries: timestamp_column_name

- column: model_column_1
label: Column label 1
description: ""
# Add more dimensions here

- label: "Count"
name: "count"
expression: count(*)
description: ""
format_preset: "humanize"
# Add more measures here
Check our reference documentation

For more information about available dashboard properties, feel free to check our reference YAML documentation.

Multi-editor and external IDE support

Rill Developer is meant to be developer friendly and has been built around the idea of keystroke-by-keystroke feedback when modeling your data, allowing live interactivity and a real-time feedback loop to iterate quickly (or make adjustments as necessary) with your models and dashboards. Additionally, Rill Developer has support for the concept of "hot reloading", which means that you can keep two windows of Rill open at the same time and/or use a preferred editor of choice, such as VSCode, side-by-side with the dashboard that you're actively developing!