Widgets
Dashboard Widgets
Widgets are the building blocks of dashboards. Each widget displays the result of a query in a specific format. This page covers all available widget types and their configuration options.
Metric Card
Displays a single number prominently. Ideal for KPIs like total revenue, active users, or open tickets.
Configuration:
- Label -- the metric name displayed above the number
- Format -- number, currency, percentage, or custom format string
- Comparison -- show the change vs. previous period (day, week, month, quarter)
- Trend indicator -- green/red arrow showing the direction of change
- Goal -- set a target value and display progress toward it
Table Widget
Displays tabular data with sorting, filtering, and pagination. Best for detailed lists and records.
Configuration:
- Columns -- select which columns to show and in what order
- Column formatting -- set data types, alignment, and custom formatters per column
- Row limit -- how many rows to display (paginated)
- Conditional formatting -- highlight cells based on rules (e.g., red if value > threshold)
- Row click action -- link rows to external URLs or other dashboards
Bar Chart
Compares values across categories. Supports horizontal and vertical orientations.
Configuration:
- X-axis -- the category field
- Y-axis -- the value field(s), supports multiple series
- Stacking -- stacked or grouped bars
- Colors -- customize colors per series
- Sort -- by value or by category name
Line Chart
Shows trends over time. Supports multiple series and trend lines.
Configuration:
- X-axis -- typically a date/time field
- Y-axis -- one or more value fields
- Interpolation -- linear, smooth, or step
- Trend line -- add a linear or moving-average trend line
- Annotations -- mark specific dates or events
Pie Chart
Shows proportional breakdown. Best when you have fewer than 8 categories.
Configuration:
- Category -- the grouping field
- Value -- the measure field
- Labels -- show percentages, values, or both
- "Other" threshold -- group small slices into "Other" below a percentage threshold
Text Block
A free-form text widget for adding context, instructions, or section headers to your dashboard. Supports Markdown formatting.
Ready to try this on your own database?
Connect in minutes and ask your first question — no SQL required.
Start freeFree plan · No credit card required