Canvas Docs
  • GETTING STARTED
    • Our docs have moved
    • Connect your data
      • App and database connectors
      • Snowflake
      • BigQuery
      • Redshift
      • Postgres
        • Use an SSH tunnel
      • Static IP Addresses
      • dbt
        • dbt Cloud
        • dbt via GitHub
    • Create your first canvas
    • Onboarding your team
  • Building canvases
    • Import data
    • Formulas
    • SQL
    • Joins
    • Pivot tables
    • Charts
    • Filters
      • Date filters
      • Text search filters
      • Multi-select filters
    • Canvas API
    • Events API
    • Embed Login API
  • Embeds
    • Public Embeds
    • Scopes
    • Walkthrough
    • PowerPoint embeds
  • Managing users
    • Assigning permissions
  • Security
    • Data security
    • Bug bounty program
    • Privacy policy
    • Terms of service
Powered by GitBook
On this page
  1. Building canvases

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. 🔮

PreviousJoinsNextCharts

Last updated 2 years ago

  • 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