Usage Insights data options for pivot table data visualizations

  • Release version: Zurich
  • Updated July 31, 2025
  • 2 minutes to read

    • When you select a Usage Insights data source for a pivot table visualization, the following Data configuration options are available.

    Important:
    Pivot table visualizations are only suitable for Events data, not Users or Sessions. Only Events have a value to group by.
    Field Description
    Data

    Data source

    You have selected a Usage Insights data source in Create a pivot table data visualization in the Visualization Designer.
    Metric
    Metric Label of the metric. By default it is the same as the name of the data source: Events or Sessions.

    For sessions, you can configure the metric to reflect the number of sessions, average session duration, average pages per session, or average sessions per user.
    Format values Select to open the Formatting values dialog. For more information, see Value formatting in reports.
    Group by

    Columns
    Properties of the Usage Insights data source.
    Note:
    Available only for Events and Sessions metrics, in which case it is mandatory.

    Rows

    		 Hierarchy of table fields with values displayed horizontally.

    Event property

    Choice of properties of the data source to select for a column or row.

    Show row total

    Show the total value of elements in each row.
    Show column total Show the total value of elements at the bottom of each column.
    Show parent row totals For a hierarchy of rows, show the total of all child rows per column, depending on metric aggregation.

    Additional settings
    Show 0 when no data is available When toggled on, shows empty (NULL) values as zero (0). Default is true.
    Data update
    Follow filters Follow filters set for a page. When enabled, the visualization displays on a workspace with the filters set by the page. Toggle off to disable a visualization from accepting any filter input.
    Show filter icon Option to show the filter icon and the number of filters impacting the visualization. If a filter is not selected to apply to a visualization, the icon does not show. Toggle off to hide the filter icon and number of filters applied.
    Refresh after being away for X min. Triggered when you navigate away from the dashboard that contains the data visualization to another page in the same workspace, includingPlatform Analytics experience. Sets how many minutes you will be on another page before the visualization automatically refreshes when you navigate back.

    Do not confuse this property with the Scheduled repetition setting on inline dashboards. This latter property refreshes the entire dashboard, and applies only while that dashboard is open.
    Info messages
    Set custom message when no data Option to configure a custom message that displays when no data is returned.
    Illustration An illustration to include in the message.
    Heading Header text of the message that describes why no data was returned.
    Heading level Header text size for the message that describes why no data was returned.
    Content Secondary text of the message that provides additional detail.
    Alignment The alignment of the illustration and text in the message.