Comment on page
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
pivoticon 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
Last modified 7mo ago