Explore Dashboard YAML

Explore dashboards provide an interactive way to explore data with predefined measures and dimensions.

Properties

`type`

[string] - Refers to the resource type and must be explore (required)

`display_name`

[string] - Refers to the display name for the explore dashboard

`metrics_view`

[string] - Refers to the metrics view resource (required)

`description`

[string] - Refers to the description of the explore dashboard

`banner`

[string] - Refers to the custom banner displayed at the header of an explore dashboard

`ai_prompts`

[array of oneOf] - Suggested prompts shown as starters in the AI chat for this dashboard. Each entry is either a prompt string or an object with label and prompt. If not set, the project-level ai_prompts from rill.yaml are shown instead. At most 8 distinct entries.

option 1 - [string] - The prompt. A short label is derived from its first words.
option 2 - [object] - A prompt with an explicit label.
- label - [string] - Short label shown on the prompt's button (at most 40 characters). Derived from the prompt if omitted.
- prompt - [string] - The full question sent to the AI when the user picks the prompt. (required)

- Which campaigns drove the biggest change in impressions this week?
- label: CTR outliers
  prompt: Which publishers have a click-through rate far above or below the average?

`dimensions`

[oneOf] - List of dimension names. Use '*' to select all dimensions (default)

option 1 - [string] - Wildcard(*) selector that includes all available fields in the selection
option 2 - [array of string] - Explicit list of fields to include in the selection
option 3 - [object] - Advanced matching using regex, DuckDB expression, or exclusion
- regex - [string] - Select fields using a regular expression
- expr - [string] - DuckDB SQL expression to select fields based on custom logic
- exclude - [object] - Select all fields except those listed here

# Example: Select a dimension
dimensions:
    - country

# Example: Select all dimensions except one
dimensions:
    exclude:
        - country

# Example: Select all dimensions that match a regex
dimensions:
    expr: "^public_.*$"

`measures`

[oneOf] - List of measure names. Use '*' to select all measures (default)

option 1 - [string] - Wildcard(*) selector that includes all available fields in the selection
option 2 - [array of string] - Explicit list of fields to include in the selection
option 3 - [object] - Advanced matching using regex, DuckDB expression, or exclusion
- regex - [string] - Select fields using a regular expression
- expr - [string] - DuckDB SQL expression to select fields based on custom logic
- exclude - [object] - Select all fields except those listed here

# Example: Select a measure
measures:
    - sum_of_total

# Example: Select all measures except one
measures:
    exclude:
        - sum_of_total

# Example: Select all measures that match a regex
measures:
    expr: "^public_.*$"

`theme`

[oneOf] - Name of the theme to use. Only one of theme and embedded_theme can be set.

option 1 - [string] - Name of an existing theme to apply to the dashboard
option 2 - [object] - Inline theme configuration.
- colors - [object] - Used to override the dashboard colors. Either primary or secondary color must be provided.
  - primary - [string] - Overrides the primary blue color in the dashboard. Can have any hex, named colors or hsl() formats. Note that the hue of the input colors is used for variants but the saturation and lightness is copied over from the blue color palette.
  - secondary - [string] - Overrides the secondary color in the dashboard. Applies to the loading spinner only as of now. Can have any hex, named colors or hsl() formats.
- light - [object] - Light theme color configuration
  - primary - [string] - Primary color for light theme. Can have any hex, named colors or hsl() formats.
  - secondary - [string] - Secondary color for light theme. Can have any hex, named colors or hsl() formats.
  - kpi-positive - [string] - Color for positive KPI delta values in light theme. Defaults to fg-secondary (gray).
  - kpi-negative - [string] - Color for negative KPI delta values in light theme. Defaults to red.
  - variables - [object] - Custom CSS variables for light theme
- dark - [object] - Dark theme color configuration
  - primary - [string] - Primary color for dark theme. Can have any hex, named colors or hsl() formats.
  - secondary - [string] - Secondary color for dark theme. Can have any hex, named colors or hsl() formats.
  - kpi-positive - [string] - Color for positive KPI delta values in dark theme. Defaults to fg-secondary (gray).
  - kpi-negative - [string] - Color for negative KPI delta values in dark theme. Defaults to red.
  - variables - [object] - Custom CSS variables for dark theme

`time_ranges`

[array of oneOf] - Overrides the list of default time range selections available in the dropdown. It can be a string or an object with a 'range' and optional 'comparison_offsets'.

time_ranges:
  - PT15M // Simplified syntax to specify only the range
  - PT1H
  - PT6H
  - P7D
  - range: P5D // Advanced syntax to specify comparison_offsets as well
  - P4W
  - rill-TD // Today
  - rill-WTD // Week-To-date

option 1 - [string] - An ISO 8601 duration or one of the Rill ISO 8601 extensions extensions for the selection.
option 2 - [object] - Object containing time range and comparison configuration
- range - [string] - An ISO 8601 duration or one of the Rill ISO 8601 extensions extensions for the selection. (required)
- comparison_offsets - [array of oneOf] - List of time comparison options for this time range selection (optional). Must be one of the Rill ISO 8601 extensions.
  - option 1 - [string] - Offset string only (range is inferred)
  - option 2 - [object] - Object containing offset and range configuration for time comparison
    - offset - [string] - Time offset for comparison (e.g., 'P1D' for one day ago)
    - range - [string] - Custom time range for comparison period

`time_zones`

[array of string] - Refers to the time zones that should be pinned to the top of the time zone selector. It should be a list of IANA time zone identifiers

`lock_time_zone`

[boolean] - When true, the dashboard will be locked to the first time provided in the time_zones list. When no time_zones are provided, the dashboard will be locked to UTC

`allow_custom_time_range`

[boolean] - Defaults to true, when set to false it will hide the ability to set a custom time range for the user.

`defaults`

[object] - Defines the defaults YAML struct.

defaults: #define all the defaults within here
  dimensions:
    - dim_1
    - dim_2
  measures:
    - measure_1
    - measure_2
  time_range: P1M
  comparison_mode: dimension #time, none
  comparison_dimension: filename

dimensions - [oneOf] - Provides the default dimensions to load on viewing the dashboard
- option 1 - [string] - Wildcard(*) selector that includes all available fields in the selection
- option 2 - [array of string] - Explicit list of fields to include in the selection
- option 3 - [object] - Advanced matching using regex, DuckDB expression, or exclusion
  - regex - [string] - Select fields using a regular expression
  - expr - [string] - DuckDB SQL expression to select fields based on custom logic
  - exclude - [object] - Select all fields except those listed here
measures - [oneOf] - Provides the default measures to load on viewing the dashboard
- option 1 - [string] - Wildcard(*) selector that includes all available fields in the selection
- option 2 - [array of string] - Explicit list of fields to include in the selection
- option 3 - [object] - Advanced matching using regex, DuckDB expression, or exclusion
  - regex - [string] - Select fields using a regular expression
  - expr - [string] - DuckDB SQL expression to select fields based on custom logic
  - exclude - [object] - Select all fields except those listed here
time_range - [string] - Refers to the default time range shown when a user initially loads the dashboard. The value must be either an ISO 8601 duration (for example, PT12H for 12 hours, P1M for 1 month, or P26W for 26 weeks) or one of the Rill ISO 8601 extensions.
comparison_mode - [string] - Controls how to compare current data with historical or categorical baselines. Options: none (no comparison), time (compares with past based on default_time_range), dimension (compares based on comparison_dimension values)
comparison_dimension - [string] - For dimension mode, specify the comparison dimension by name.

`embeds`

[object] - Configuration options for embedded dashboard views

hide_pivot - [boolean] - When true, hides the pivot table view in embedded mode

`security`

[object] - Defines security rules and access control policies for dashboards (without row filtering)

access - [oneOf] - Expression indicating if the user should be granted access to the dashboard. If not defined, it will resolve to false and the dashboard won't be accessible to anyone. Needs to be a valid SQL expression that evaluates to a boolean.
- option 1 - [string] - SQL expression that evaluates to a boolean to determine access
- option 2 - [boolean] - Direct boolean value to allow or deny access

Common Properties

`name`

[string] - Name is usually inferred from the filename, but can be specified manually.

`refs`

[array of string] - List of resource references

`tags`

[array of string] - Tags for organizing and filtering the resource (e.g. on the project dashboards list).

`metadata`

[object] - User-defined key-value metadata attached to the resource. Rill does not read or write it; it is exposed as-is on the resource's meta over the API for external tooling. Values are strings, with numbers and booleans coerced. Not supported in rill.yaml defaults.

`dev`

[object] - Overrides any properties in development environment.

`prod`

[object] - Overrides any properties in production environment.

Properties​

type​

display_name​

metrics_view​

description​

banner​

ai_prompts​

dimensions​

measures​

theme​

time_ranges​

time_zones​

lock_time_zone​

allow_custom_time_range​

defaults​

embeds​

security​

Common Properties​

name​

refs​

tags​

metadata​

dev​

prod​