Usage Insights data options for pivot table visualizations

  • Release version: Washingtondc
  • Updated February 1, 2024
  • 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, Events application, in Create a pivot table visualization.
    Metric
    Label Label of the metric. By default it is the same as the name of the data source.
    Format values Select to open the Formatting values dialog. For more information, see Value formatting in reports.
    Group by

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

    Rows

    		 Hierarchy of table fields with values displayed horizontally.

    Event property

    Choice of properties of the event 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 zero 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.
    No data message
    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.
    Content Secondary text of the message that provides additional detail.
    Alignment The alignment of the illustration and text in the message.