Skip to content

Board Examples

Advanced layout patterns and comprehensive examples.

Marketing Command Center

A complex dashboard combining multiple layout types, content, and charts:

source: examples_db
title: "Marketing Command Center"

queries:
  sales_summary:
    sql: |
      SELECT SUM(revenue) AS revenue, SUM(units_sold) AS units_sold, COUNT(DISTINCT category) AS category_count FROM ecommerce_orders
  sales_by_date:
    sql: |
      SELECT date, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY date ORDER BY date
  sales_by_category:
    sql: |
      SELECT category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY category ORDER BY revenue DESC
  sales_by_product:
    sql: |
      SELECT product, category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY product, category ORDER BY revenue DESC
  sales:
    sql: |
      SELECT * FROM ecommerce_orders

charts:
  spend:
    query: sales_summary
    type: kpi
    label: "Total Revenue"
    value: revenue
  clicks:
    query: sales_summary
    type: kpi
    label: "Total Units"
    value: units_sold
  roi:
    query: sales_summary
    type: kpi
    label: "Categories"
    value: category_count
  spend_trend:
    query: sales_by_date
    type: line
    title: "Revenue Over Time"
    x: date
    y: revenue
  channel_mix:
    query: sales_by_category
    type: bar
    title: "Category Mix"
    x: category
    y: revenue
  funnel:
    query: sales_by_product
    type: bar
    title: "Product Funnel"
    x: product
    y: units_sold
  conversion:
    query: sales
    type: table
    title: "Sales Table"
  campaigns:
    query: sales
    type: table
    title: "Campaign Table"
  creative1:
    query: sales_by_date
    type: bar
    x: date
    y: revenue
  creative2:
    query: sales_by_category
    type: bar
    x: category
    y: units_sold
  creative3:
    query: sales_by_product
    type: pie
    theta: revenue
    color: product

rows:
  # Section 1: Top Level KPIs
  - height: "120px"
    cols:
      - spend
      - clicks
      - roi

  # Section 2: Main Trends (Split 50/50)
  - cols:
      - spend_trend
      - channel_mix

  # Section 3: Funnel Analysis
  - rows:
      - text: |
          **Funnel Performance**
          Analyzing conversion rates by product
      - cols:
          - funnel
          - conversion

  # Section 4: Detailed Reports (Tabs)
  - tabs:
      items:
        - title: "Campaigns"
          rows:
            - campaigns

        - title: "Creatives"
          cols:
            - creative1
            - creative2
            - creative3
Marketing Command Center 440k Total Revenue 15k Total Units 3 Categories 1 Jan20242 Jan3 Jan4 Jan5 Jan6 Jan7 Jan8 Jan9 Jan10 Jan11 Jan12 Jan13 Jan14 Jan15 Jan16 Jan17 Jan18 Jan19 Jan20 Jan21 Jan22 Jan23 Jan24 Jan25 Jan26 Jan27 Jan28 Jan29 Jan30 Jan010k20k30kRevenue Over Time020k40k60k80k100k120k140k160k180k200kElectronicsAccessoriesToolsCategory Mix Funnel Performance Analyzing conversion rates by product 02004006008001k1.2k1.4k1.6k1.8k2k2.2k2.4k2.6k2.8kWidget BWidget CGadget YWidget AGadget XTool ZTool AGadget ZProduct Funnel Sales TableDateRegionProductCategoryRevenueUnits Sold26 Jan 2024EastWidget AElectronics1.5K5014 Jan 2024EastGadget YAccessories3K10013 Jan 2024NorthWidget BElectronics1.46K5210 Jan 2024EastWidget CElectronics1.25K5023 Jan 2024EastWidget AElectronics2.16K7229 Jan 2024EastWidget AElectronics3.6K12029 Jan 2024EastGadget YAccessories1.89K6319 Jan 2024SouthWidget BElectronics1.4K5016 Jan 2024EastGadget XAccessories2.24K665 Jan 2024SouthWidget BElectronics6162213 Jan 2024NorthGadget YAccessories2.01K675 Jan 2024EastWidget CElectronics3.2K12825 Jan 2024NorthWidget AElectronics1.26K4220 Jan 2024WestWidget AElectronics1.05K3530 Jan 2024EastGadget XAccessories2.07K6126 Jan 2024SouthWidget AElectronics1.53K519 Jan 2024WestGadget XAccessories1.22K3626 Jan 2024WestTool ZTools1.79K5623 Jan 2024WestWidget BElectronics5321911 Jan 2024SouthWidget CElectronics3.05K122 ‹ 1 2 … 12 › Campaigns Creatives Campaigns Campaign TableDateRegionProductCategoryRevenueUnits Sold26 Jan 2024EastWidget AElectronics1.5K5014 Jan 2024EastGadget YAccessories3K10013 Jan 2024NorthWidget BElectronics1.46K5210 Jan 2024EastWidget CElectronics1.25K5023 Jan 2024EastWidget AElectronics2.16K7229 Jan 2024EastWidget AElectronics3.6K12029 Jan 2024EastGadget YAccessories1.89K6319 Jan 2024SouthWidget BElectronics1.4K5016 Jan 2024EastGadget XAccessories2.24K665 Jan 2024SouthWidget BElectronics6162213 Jan 2024NorthGadget YAccessories2.01K675 Jan 2024EastWidget CElectronics3.2K12825 Jan 2024NorthWidget AElectronics1.26K4220 Jan 2024WestWidget AElectronics1.05K3530 Jan 2024EastGadget XAccessories2.07K6126 Jan 2024SouthWidget AElectronics1.53K519 Jan 2024WestGadget XAccessories1.22K3626 Jan 2024WestTool ZTools1.79K5623 Jan 2024WestWidget BElectronics5321911 Jan 2024SouthWidget CElectronics3.05K122 ‹ 1 2 … 12 › Data as of 16:49 UTC on 5 Aug 2026 made with dataface
▶

Nested Grids

Create sophisticated layouts by combining multiple layout types:

source: examples_db
title: "Complex Dashboard"

queries:
  sales_summary:
    sql: |
      SELECT SUM(revenue) AS revenue, SUM(units_sold) AS units_sold, COUNT(DISTINCT category) AS category_count FROM ecommerce_orders
  sales_by_category:
    sql: |
      SELECT category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY category ORDER BY revenue DESC
  sales_by_product:
    sql: |
      SELECT product, category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY product, category ORDER BY revenue DESC
  sales_by_date_category:
    sql: |
      SELECT date, category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY date, category ORDER BY date, category

charts:
  kpi1:
    query: sales_summary
    type: kpi
    label: "Revenue"
    value: revenue
  kpi2:
    query: sales_summary
    type: kpi
    label: "Units Sold"
    value: units_sold
  mini1:
    query: sales_by_category
    type: bar
    title: "Mini Chart 1"
    x: category
    y: revenue
  mini2:
    query: sales_by_product
    type: bar
    title: "Mini Chart 2"
    x: product
    y: units_sold
  main:
    query: sales_by_date_category
    type: line
    title: "Main Analysis"
    x: date
    y: revenue
    color: category

rows:
  - cols:
      - kpi1
      - kpi2
      - cols:
          - mini1
          - mini2
  - main
Complex Dashboard 440k Revenue 15k Units Sold 0100k200kElectronicsAccessoriesToolsMini Chart 101k2kWidget BWidget CGadget YWidget AGadget XTool ZTool AGadget ZMini Chart 2 1 Jan20242 Jan3 Jan4 Jan5 Jan6 Jan7 Jan8 Jan9 Jan10 Jan11 Jan12 Jan13 Jan14 Jan15 Jan16 Jan17 Jan18 Jan19 Jan20 Jan21 Jan22 Jan23 Jan24 Jan25 Jan26 Jan27 Jan28 Jan29 Jan30 Jan05k10k15k20kMain AnalysisElectronicsAccessoriesTools Data as of 16:49 UTC on 5 Aug 2026 made with dataface
▶

Document-Style Report

source: examples_db
title: "Analytical Report"

queries:
  sales_by_category:
    sql: |
      SELECT category, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY category ORDER BY revenue DESC
  sales_by_date_product:
    sql: |
      SELECT date, product, SUM(revenue) AS revenue, SUM(units_sold) AS units_sold FROM ecommerce_orders GROUP BY date, product ORDER BY date, product

charts:
  revenue_by_category:
    query: sales_by_category
    type: bar
    title: "Revenue by Category"
    x: category
    y: revenue
  trends:
    query: sales_by_date_product
    type: line
    title: "Trend Analysis"
    x: date
    y: revenue
    color: product

rows:
  - text: |
      # Monthly Performance Report
      This month showed **strong growth** across all key metrics.
      The following visualizations break down the performance by category.

  - cols:
      - revenue_by_category

      - text: |
          ### Key Insights
          - **Electronics**: Leading category with 35% growth
          - **Accessories**: Needs attention, down 5%
          - **Tools**: Steady performance

  - trends
Analytical Report Monthly Performance Report This month showed strong growth across all key metrics. The following visualizations break down the performance by category. 0100k200k50k150kElectronicsAccessoriesToolsRevenue by Category Key Insights Electronics: Leading category with 35% growth Accessories: Needs attention, down 5% Tools: Steady performance 1 Jan20242 Jan3 Jan4 Jan5 Jan6 Jan7 Jan8 Jan9 Jan10 Jan11 Jan12 Jan13 Jan14 Jan15 Jan16 Jan17 Jan18 Jan19 Jan20 Jan21 Jan22 Jan23 Jan24 Jan25 Jan26 Jan27 Jan28 Jan29 Jan30 Jan05k10kTrend AnalysisWidget ATool ZGadget XWidget CWidget BGadget ZGadget YTool A Data as of 16:49 UTC on 5 Aug 2026 made with dataface
▶

Best Practices

Logical Grouping

Use boards to group related charts together. This improves readability and organization.

Layout Selection

Layout Best For
Rows Simple vertical flow, mobile, scrolling
Cols Side-by-side comparisons, sidebars
Grid Precise control, dense dashboards
Tabs Managing density, hiding content until needed

Modularity

Extract complex boards into separate files (starting with _ for partials) and include them by referencing their filename.

Performance

  • Keep individual boards focused
  • Use tabs to lazy-load complex sections
  • Split large dashboards into multiple files