Widgets and queries
A widget's three data sources, grouping and metric, the Other rollup, the display controls, a per-widget time range and click-through.
A widget is built from two independent halves: where the data comes from, and how it is drawn. The same query can be a counter, a bar list or a pivot table.
Three data sources
| Mode | What it is | Where it runs |
|---|---|---|
| Ready-made source | Prepared views over events | On the server |
| Query | A data source, filters, up to three grouping levels and a metric | In the browser |
| Advanced | An expression from the data explorer | On the server |
Advanced mode takes the same expression language the data explorer uses, and an expression can be pasted in from there unchanged. In such a widget the chart type, grouping, sort and limit are set inside the expression itself, and the panel supplies only colors, size and a title.
Grouping and metric
Up to three levels — primary, secondary, tertiary — and one metric: count, distinct values, sum or average.
Each level is ordered by size or by the field's own order. The second honors the option order defined for the field, so a severity ramp stays critical → high → medium → low instead of sorting itself alphabetically.
Each level has a maximum number of groups. Groups past that number are folded into a single group called Other, and its label says how many groups it covers. At deeper levels "Other" keeps splitting — it is not an empty column at the end.
Filters
The filter vocabulary is the data explorer's vocabulary, not a second one: the field decides which operators are offered.
Chart types
The gallery is organized into seven categories: metrics · rank · distribution · part of whole · evolution · flow and structure · table.
The picker marks ★ beside the types that suit the shape of the query you built. The display controls follow from the type — a bar list has no legend to hide, a pie has no gridlines — because a switch that visibly does nothing is worse than one that is absent.
Display
- Legend — on or off, and its position is expressed in reading order, so one board looks right in both languages.
- Numbers on the chart — beside the bars, above the columns or on the pie slices, and you choose what the number says.
- Gridlines — the horizontal guides behind the chart.
- Vertical overflow — scroll, or pages: in pages exactly the rows that fit are shown, with paging at the bottom of the widget.
- Colors — a ready-made set or a free choice. Colors are assigned in order, and the list wraps when there are fewer colors than categories.
- Color thresholds — a base color and steps above it, coloring either the number itself or its background, and drawing the gauge's bands.
A range of its own
The default is to follow the board's picker. A widget can be given its own range — and then it carries a marker naming it. A source that is not time-scoped shows "not relevant" and gets no picker at all.
Clicking a group
Clicking a bar or a slice on a query widget opens that entity's table, filtered by the widget's own filters plus the group that was clicked.
Building a full expression, relations between entities and adding a result to a board are covered in Data explorer.
Updated
This page is the file content/docs/en/v1/report/widgets-and-queries.mdx