Canvas Docs

Pivot tables

You can use pivot tables to aggregate data for quick insights. You just need to build the pivot once and watch the data update in real-time. 🔮
  • To summarize data as a pivot table, highlight the table by clicking the upper-left of the table. Then select the pivot icon in the navigation bar.
  • A blank pivot table will display on the canvas, while a menu will appear to configure the pivot table.
  • Drag a single source field or multiple source fields into a panel below to visualize data as a row, column, or value.
  • For Rows or Columns, select the Details icon and select the sort order to sort a row or column source field.
  • For Values, select the Details icon to summarize a value by any of the following:
    • Count Unique
    • Count
    • Sum
    • Average
    • Minimum
    • Maximum