Skip to content

Drill-Down Example (Planned)

Coming Soon

Click-to-filter drill-down dashboards are planned but not implemented. Strict chart validation rejects interactions: today; do not paste a chart-level interactions: block into a face.

A planned board pattern for click filtering and drill-down navigation.

Planned Behavior

The goal is to allow users to click on chart elements to filter detail views. That behavior does not have an accepted YAML schema yet. A future design needs to define and test a new surface for:

  • setting a variable from the clicked row
  • filtering one or more target charts
  • navigating to another board or external URL

For URL navigation today, use the supported chart-level href: field with a URL column or template:

queries:
  tickets:
    sql: |
      select
        status,
        count(*) as tickets,
        '/zendesk/tickets?status=' || status as ticket_url
      from tickets
      group by status

rows:
  - tickets_by_status:
      title: "Tickets by Status"
      query: tickets
      type: bar
      x: status
      y: tickets
      href: ticket_url

Planned Click Action Types

Set Variable

Planned behavior: update a variable from the clicked row. No supported YAML field exists for this yet.

Filter Other Charts

Planned behavior: filter other charts when clicking a mark. No supported YAML field exists for this yet.

Navigate to another board or external URL. Board links use dashboard-root paths and are resolved automatically — see Linking Between Boards. This case is supported today with href::

charts:
  tickets:
    type: bar
    query: tickets_by_status
    x: status
    y: tickets
    href: ticket_url

Current Alternative: Use Dropdown Variables

Until click interactions are implemented, you can achieve similar filtering behavior using dropdown variables:

title: "Sales Board with Filters"

variables:
  selected_month:
    label: "Select Month"
    input: select
    options:
      static: ["2024-01", "2024-02", "2024-03", "2024-04"]

queries:
  monthly_detail:
    metrics: [total_revenue, order_count]
    dimensions: [day, product]
    filters:
      month: "{{ selected_month }}"

rows:
  - cols:
      - detail_chart:
          title: "Daily Sales for {{ selected_month }}"
          query: queries.monthly_detail
          type: line
          x: day
          y: total_revenue