Skip to main content

Create a table

Build a Studio table of totals by group, raw records, date comparisons, pace, KPIs and more.

Use a table when people need exact numbers, for example load count and revenue for every customer category. The Studio offers eight table types, so pick the type first.

Table types

Type

What each row is

Metrics

Totals by dimension or date

Records

A dataset's rows, field by field

Date comparison

Each interval against an earlier average

Pace

Each day so far, and the projected total

Entity details

An entity page's fields and metrics

Reminders

Upcoming and overdue events, by date

Metric list

Each metric's value and change

KPI list

A KPI List's KPIs against their targets

Build a metrics table

  1. In the Gadgets tab, click Table.

  2. Under Type, keep Metrics.

  3. Click Add a metric and pick the first column, for example Load Count.

  4. Click Add metric to add more columns, for example Total Revenue. Drag the handle on a metric to change the column order.

  5. Use Add field column to show a plain field next to the metrics.

  6. Under Dimensions, click Add dimension and pick the field for the rows, for example Customer Category.

    Table gadget showing Load Count and Total Revenue by Customer Category, with the Type, Metrics and Dimensions settings highlighted
  7. Save the report or dashboard.

The table shows a total row at the bottom, and viewers can sort by any column.

Want a list of individual loads or orders instead of totals? Choose the Records type and pick the fields to show.

What's next

Did this answer your question?