Dashboard Builder

Builder Overview

The dashboard builder consists of three main areas:

Adding Visualizations

There are three ways to add visualizations to your dashboard:

1. From Metrics Registry

Drag metrics from the sidebar to automatically create visualizations with the correct aggregations and formatting.

2. Custom SQL Query

Write custom SQL for ad-hoc analysis not covered by your metrics registry:

SELECT
  DATE_TRUNC('month', order_date) AS month,
  product_category,
  SUM(revenue) AS revenue,
  COUNT(DISTINCT customer_id) AS customers
FROM orders
WHERE order_date >= DATE_ADD(CURRENT_DATE, INTERVAL -12 MONTH)
GROUP BY 1, 2
ORDER BY 1, 2

3. AI Suggestions

Click Suggest Views to let Lucaro analyze your data and recommend visualizations:

• KPI cards for key metrics
• Time series for trends
• Comparisons between dimensions
• Anomaly highlights

Configuring Views

Each view has configurable properties in the right sidebar:

Layout and Sizing

The canvas uses a flexible grid system:

• Drag to move - Grab the title bar to reposition views
• Resize handles - Drag corners or edges to resize
• Snap to grid - Views automatically align to the grid
• Responsive - Dashboard adapts to different screen sizes

Dashboard Specification

Dashboards are defined as JSON specifications that can be exported and version controlled:

{
  "title": "Sales Dashboard",
  "description": "Monthly sales performance overview",
  "views": [
    {
      "id": "revenue-card",
      "title": "Total Revenue",
      "chart_type": "number",
      "metric": "monthly_revenue",
      "format": "currency"
    },
    {
      "id": "revenue-trend",
      "title": "Revenue Trend",
      "chart_type": "line",
      "metric": "monthly_revenue",
      "dimension": "order_date",
      "filters": [
        {"field": "order_date", "operator": ">=", "value": "-12 months"}
      ]
    },
    {
      "id": "revenue-by-region",
      "title": "Revenue by Region",
      "chart_type": "bar",
      "metric": "monthly_revenue",
      "dimension": "region"
    }
  ],
  "filters": [
    {"name": "date_range", "type": "date_range", "default": "last_30_days"},
    {"name": "region", "type": "multi_select", "dimension": "region"}
  ]
}

Keyboard Shortcuts