Skip to main content
Regulaxy

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

ModeWhat it isWhere it runs
Ready-made sourcePrepared views over eventsOn the server
QueryA data source, filters, up to three grouping levels and a metricIn the browser
AdvancedAn expression from the data explorerOn 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