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.
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 do | What happens |
|---|---|
| Click a field with no visual selected | A new visual is created in a free spot on the page |
| Click a field with a chart selected | The field goes into the chart (or comes out, if it was already there) |
| Drag the field onto the canvas | Creates a visual where you dropped it |
| Drag the field into a visual | It 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:
| Option | When to use it |
|---|---|
| Sum | Revenue, quantity sold |
| Average | Average ticket, average score |
| Count | How many rows (orders, visits) |
| Distinct count | How many different ones — for example, customers who bought |
| Min / Max | Smallest and largest value |
Sum and Average only appear on numeric fields.
Calculated column#
A new column in the table, calculated row by row from the others (for example, margin = price − cost).
1. Open the table
In the Fields list, open the table where the column will live.
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. Give it a name and write the formula
The preview shows the result before you save.
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.
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.
| Variable | What 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 |