Logo
DB Pro

How can we help?

Metric

Display a single prominent number on your dashboard

Displays a single prominent number. Ideal for KPIs like total revenue, user count, or conversion rate.

SQL Shape

Return at least one numeric column. Only the first row is used.

SQL
SELECT COUNT(*) AS total_users FROM users

Options

OptionDescription
FormatNumber (1,234), Decimal (1,234.56), Percent (12.5%), or Currency
Currency24 currencies supported (USD, EUR, GBP, JPY, etc.)
CompareShow percentage change against a second numeric column
Color by changeTurn the tile green (positive) or red (negative) based on comparison
BackgroundPick from 14 gradient colors

Compare Mode

When enabled, the query should return two numeric columns. The first is the current value, the second is the comparison value.

SQL
SELECT
  SUM(CASE WHEN month = 'Jan' THEN revenue END) AS current,
  SUM(CASE WHEN month = 'Dec' THEN revenue END) AS previous
FROM sales

The tile shows the current value (e.g. $52,400) with a badge like ↗ +12.5%.

Conditional Display

Metrics support conditional logic. Each condition branch can have its own display formatting and background color. See Conditional Display for details.