Dashboards let you build interactive, real-time views of your data using SQL queries. Each dashboard is a grid of tiles, and each tile is powered by its own SQL query.

Getting Started

1. Open a connection and navigate to the Dashboards tab
2. Click New Dashboard to create one
3. Draw tiles by clicking and dragging on the grid
4. Select a tile to open the Inspector sidebar, where you write SQL and configure the tile

Every tile has:

• A SQL query that returns the data
• A type that controls how the data is displayed
• An optional title shown in the top-left corner
• Optional configuration specific to the tile type

Tile Types

Each tile type expects a specific SQL shape and has its own configuration options.

• Metric displays a single prominent number
• Text displays rich text with embedded query values
• Area Chart shows stacked area trends over time
• Bar Chart compares categories with grouped bars
• Pie Chart shows proportions in a donut chart
• Sparkline shows a compact trend line
• Progress Bar shows current value vs a goal
• Table renders query results as a scrollable table
• Map places markers from latitude/longitude data
• Image displays an image selected by query conditions
• GIF displays an animated GIF selected by query conditions

Layout

• Tiles are arranged on a responsive grid
• Drag tiles to reposition them (tiles swap positions)
• Resize tiles by dragging the bottom-right handle
• Draw new tiles by clicking and dragging on empty grid space
• Right-click a tile for options: Edit, Copy, Delete
• Grid row height is 60px with 8px margins

Dashboard Settings

Access dashboard-level settings from the gear icon:

Setting	Description
Title	Display title shown centered above the grid

Auto-Refresh

Each tile can have an auto-refresh interval. When set, the tile's SQL query re-executes automatically at the specified interval. This keeps the dashboard up to date without manual refreshes.

Use the refresh button in the dashboard toolbar to manually refresh all tiles.

Conditional Display

Image, GIF, Text, and Metric tiles support conditional logic. Conditions let you change what a tile displays based on query data.

How It Works

1. The first column of the first row from your query is the evaluated value
2. Each condition has an operator, a comparison value, and a display result
3. Conditions are checked top-to-bottom
4. The last matching condition determines what is displayed
5. If nothing matches, the first condition is used as a fallback

Available Operators

Operator	Description
=	Exact string match
!=	Not equal
>	Numeric greater than
<	Numeric less than
is null	Value is null
is not null	Value exists

Text and Metric Conditions

When you add conditions to a text or metric tile, each condition branch can have its own display content and background color. This lets you build tiles that change appearance based on data:

Operator	Value	Display
>	1000	Revenue is strong: ${{revenue}} (green background)
<	500	Revenue is low: ${{revenue}} (red background)

Tile Backgrounds

14 gradient colors are available for text and metric tiles:

Slate, Red, Orange, Amber, Green, Emerald, Teal, Cyan, Blue, Indigo, Violet, Purple, Pink, Rose

When a background color is set, all text in the tile turns white for contrast.