Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

Updated on 2026-10-03

Fields, measures and variables in the editor

The dashboard editor's Fields list — search for a field, "Add as…", calculated column, view the table's data, grouped Measures and Variables for the header and text boxes.

On this page (7)

Text in bold is the name as it appears on screen.

In edit mode, with a visual selected, the Fields column sits on the right, next to the visual pane. It has three parts, one below the other: Fields (the model's tables), Measures and Variables. Everything starts collapsed: click a table or a heading to expand it.

To hide the column and gain space, use Hide the pane. To bring it back, Show the fields pane.

Fields column open next to the visual pane, with the search box, one expanded table and the Measures and Variables sections

Search for a field#

Type in "Search field…". The list shows only the tables that have a field with that name — including calculated columns. If nothing matches: "No fields found."

Next to each table's name:

  • the selected visual's table is marked ("This is the selected visual's table.");
  • a table with no relationship to it warns you: "Not related to the visual's table: a field from here won't combine with it.";
  • the eye icon, View this table's data (100-row sample).

A table that isn't in the model yet appears with a button to open it — it then joins the model.

Put a field on a visual#

You doWhat happens
Click a field with no visual selectedA new visual is created in a free spot on the page
Click a field with a chart selectedThe field goes into the chart (or comes out, if it was already there)
Drag the field onto the canvasCreates a visual where you dropped it
Drag the field into a visualIt goes to the right place: axis, value or legend

A number goes in as Sum; text and dates go on the axis.

Add as…

On a field, the Add as… button chooses how the value goes in:

OptionWhen to use it
SumRevenue, quantity sold
AverageAverage ticket, average score
CountHow many rows (orders, visits)
Distinct countHow many different ones — for example, customers who bought
Min / MaxSmallest and largest value

Sum and Average only appear on numeric fields.

Add as… menu open on a field, with Sum, Average, Count, Distinct count, Min and Max

Calculated column#

A new column in the table, calculated row by row from the others (for example, margin = price − cost).

  1. 1. Open the table

    In the Fields list, open the table where the column will live.

  2. 2. Click New calculated column

    The link is at the end of the table's field list. It opens the formula editor, with help, function search and a preview.

  3. 3. Give it a name and write the formula

    The preview shows the result before you save.

  4. 4. Save

    Click Save. If there's an error, the text stays in the editor so you can fix it. The column appears in the table with the ƒ symbol.

To change it later, use Edit formula next to the column. Delete asks for confirmation first and shows what depends on it.

Formula editor open for a new calculated column, with the result preview

Measures#

The Measures section gathers the dashboard's calculations (Σ).

  • One row per measure. If the same calculation is in several visuals, it appears only once, with "in 3 visuals".
  • Hovering shows the formula and which visuals it's in.
  • Edit formula opens the editor.
  • unify saves the measure as a model measure — a single one for the whole dashboard. If there's another measure with the same name and a different calculation, the product doesn't unify them and tells you why: rename one of them.

To create measures, see Measures, formulas and KPIs.

Variables#

Text that fills itself in, in the header, the footer and any text box. Drag onto the page (it becomes a text box) or click to copy.

VariableWhat it shows
{{data}}issue date (dd/mm/yyyy)
{{hora}}issue time
{{data_hora}}issue date and time
{{mes}}month name (e.g., July)
{{mes_ano}}month/year (e.g., July/2026)
{{ano}}year
{{painel}}dashboard name
{{dados_de}}when the data was refreshed
{{extracao}}data extraction date and time
{{atualizado_em}}last refresh (date and time)
{{exibicao}}view date (when it's being viewed)
{{aba}}current tab (page) name
{{periodo}}filtered period (from … to)
{{periodo_de}}start of the filtered period
{{periodo_ate}}end of the filtered period
Measures and Variables sections open in the Fields column

Next task#

Related links