Pivot Tables

Pivot tables expand capabilities of regular (flat) tables by allowing you to reorganize and summarize selected data beyond the typical row-column relationship.

A pivot table can have up to 20 attribute rows and 20 attribute columns to refine data in your visualization. The data is then merged according to the attribute order in the Rows/Columns sections.

Pivot tables have the following sections:

• Metrics
• Rows
• Columns
• Configuration

In pivot tables, you can also:

• Display the values as a percentage.

• Compare your data to the previous period or the same period of the previous year.

  For details, see Time over Time Comparison.

• Group data when sorted by the first item in the Rows section.

Pivot tables automatically adjust the width of the visible columns according to the cell content. The size is calculated according to the content in the header of the column that represents the lowest level of the grouped attributes.

For information about common characteristics and settings of all visualizations, see Visualization Types.

Table Totals

You can aggregate data in a table using the following aggregate functions:

• Sum
• Max
• Min
• Avg
• Median

Steps:

1. Create a pivot table.

   For details, see Create Visualizations.

   To add table totals, the table must include at least one item in the Metrics section and one item in the Rows section.

2. Hover the mouse over a column header.

   A burger icon appears on the left side of the header.

   

3. Click the burger icon and select an aggregate function.

   A new row with the function name and appropriate values under the column is displayed.

   

   Note that you can also aggregate within individual attributes.

   

4. To add aggregate functions to all columns or to individual attributes or metrics, hover your mouse over column headers to display the burger icon.

   The following image shows the Sum function added in the Year attribute and the Avg function added in the Checkouts metric.

   

5. To delete an aggregate function, click the burger icon and click an already-selected function (with a tick sign) to hide the function row.