Report Summary Settings

mceclip0.png

 
1. Available summary columns Used to configure the Summarize by and Summary table sections of a report.
2. Chart type Choose between bar or pie chart.
3. Aggregates  A summary of the report records. There are two types:

Count - The total count for the records in the report.

Length - Summarizes the total length for all records in the report.

 

See the sample Report illustration to get more context on what you are building.

Available summary columns

This section will configure the Summarize by and the Summary table sections of a report. A report can be configured to summarize using one or more columns. You can also add additional summarize by columns for the user to modify manually in the report.  

To configure the Summary sections:

  1. Click the Add Summary Columns button.
  2. Choose the column or columns you want to Summarize by. You can add as many columns as needed.
  3. Choose the column or columns you want to summarize by when the report is opened.
  4. Click the Save button at the top right.

Note: You can modify the order of the columns by dragging the column cards to a new location.  To do this, left click the gripper icon and drag to the desired location. 

Chart Type

You can configure the report to display either a bar or pie chart.

Aggregates

To configure an Aggregate

  1. Select Aggregates Type.
  2. To add additional aggregates, select Add Aggregate.
  3. If Length is chosen
    1. Select a numerical column containing a length value.
    2. Select Unit > add conversion if necessary.
  4. Click the Save button at the top right.
  5. Go to the Site View Console to add the report to a Site View, then verify it is displayed correctly in Pivvot.