Skip to main content
Views save you from rebuilding the same pivot each time you open a table. Set it up once, and everyone who opens the view sees the same slice. A view is a saved pivot or perspective over a single table: a stored arrangement of grouping, aggregations, filters, sorting, and calculated fields. It reads live from the table, with nothing materialized, and it’s a first-class object. Views appear on the Tables page with Type = View, and dashboard cards are built on the same view shape.

​
What you can do

Build a view from the Pivoting panel, the pivot icon in the table toolbar. Its sections are Row, Column, Values, and Filter:
  • Row: group by one or more columns down the left. Ordering lives inside each Row field (its Order: and Sort by: controls), as do its Show total and Show grand total checkboxes.
  • Column: pivot columns across the top, with the same per-field total checkboxes.
  • Values: the measures to aggregate (sum, count, average, min, max, median, distinct count), plus calculated expressions.
  • Filter: restrict which rows the view includes.
Below these, an untitled card holds just Tree view and Repeat row label.
A pivoted view 'PivotedViewDemo': rows grouped by country and athlete, columns pivoted by sport (Archery, Athletics) each with sum_gold, sum_silver, sum_bronze, and sum values, and per-country total rows. The Pivoting panel on the right has Tree view and Repeat row label toggles, and Row (country, athlete), Column (year, sport), Values (sum_gold, sum_silver, sum_bronze, sum), and Filter sections. Save as New, Save, and Import are top-right.

A pivoted view and its Pivoting panel

A view is a lightweight, live slice of one table. When you need a new persisted or joinable dataset, create a calculation table instead.

​
Formatting

Style a view from the Formatting panel (the paintbrush icon in the toolbar). The button is enabled only when a view is open, so the raw Default table can’t be formatted. By default the panel targets the whole Table, with the Selected Cells option disabled; where conditional formatting is enabled, the target segments become All, Headers, and Cells. Either way the controls are cell color, text style (bold, underline, italic, strikethrough), alignment, wrapping, borders, a prefix / suffix, a multiplier, and number display.
A formatted pivot view 'A Pivot Formatted' with the sum_gold column highlighted blue. The Formatting panel on the right has a Table / Selected Cells toggle and controls for Cell Color, Text (bold, underline, italic, strikethrough), Alignment, Wrapping, Borders, Base (Prefix / Suffix), Multiplier, and Number display, plus a 'Clear Selected Formatting' action.

The Formatting panel (Selected Cells)

​
Create and manage

Open a table and use the Views dropdown in the grid toolbar. Default is the raw table; selecting a saved view opens it. Editing the pivot in the Pivoting panel starts a draft, marked “Unsaved changes”. From there:
  • Save: update the current view.
  • Save as New: promote the draft to a brand-new view.
  • Reset: discard the draft and return to the parent.
Delete a view from the trash icon on its row in the Views dropdown.
The grid toolbar for the table 'olympics_event' showing a 'Views' dropdown and, to its right, the highlighted Pivoting button (a pivot icon with a 'Pivoting' tooltip).

The table toolbar: the Views dropdown and the Pivoting button

​
Catalog

Like tables, every view carries a catalog (a description, owner, agent-facing description, and per-column descriptions) that Addison reads. Open the Catalog panel from the book icon in the view’s toolbar, the same as for a table, and see Catalog for what it holds.