Pivot Tables

This applies to: Visual Data Discovery

Pivot tables are tables of summarized statistics. They are useful for finding unique values for a field. If needed, you can add custom metrics to your pivot table metrics.

Pivot tables are supported by all Symphony data connectors except Cloudera Search. They are supported by Symphony Apache Solr connectors for version 5.2 or later.

When you select a table metric, the context menu appears. See Use the Context Menu.

When you select the More menu () in column header, you can sort your data, autosize your columns, and collapse or expand all rows for hierarchies.

After you create a pivot table, you can alter the rows, columns, metrics and metric layouts, and horizontal scroll bar used in a pivot table. In addition, you can sort the data in the table and rearrange the table fields. See the following topics:

• Configure Settings for a Specific Pivot Table
• Modify Pivot Table Rows
• Modify Pivot Table Columns and Column Widths
• Modify Pivot Table Metrics and Metric Layout
• Rearrange Pivot Table Fields
• Sort Data in a Pivot Table

You can use Keyboard Controls on the Pivot Table sidebar instead of a mouse.