Widgets

A widget is a query plus a visualization. After you run the query, the visualization step asks you to map columns onto the roles that chart understands — category, values, labels, and so on.

Pick the type that matches the shape of the result, not the other way around. Changing type later keeps the query but you will remap fields.

Widget types

Widget Best for Required mapping
Table Full result set, mixed types None — all columns are shown
Line chart Values over an ordered category (usually time) X-axis + one or more Y values
Bar chart Compare values across categories Category + one or more values
Stacked bar Parts of a whole across categories Category + stacked series
Stacked line Stacked series over an ordered category Category + stacked series
Combo chart Bars and lines on the same category Category + bar fields and/or line fields
Scatter plot Two numeric measures per row X field + Y field
Histogram Distribution of one numeric column Value field (raw rows, not pre-binned)
Pivot table Excel-style grouping and aggregations Row field + values
Pie chart Share of a total Label + value
Number A single KPI Value field

Number and date formats

Most mapped fields can override how the value is displayed: number, currency, percentage, duration, date, date-time, or a custom template. If you leave the format on Inherit, the widget uses the dashboard’s default formatting.

Use dashboard defaults in Dashboard settings → Formatting when every widget should show currency the same way. Override on a single series when only that series is a rate or a duration.

Refresh and layout

Auto-refresh is set on the query step. Size and position are set on the layout step after the visualization is configured.