Usage Insights data options for pivot table data visualizations
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. |
Parent Topic:Create a pivot table data visualization in the Visualization Designer