Adding total rows to table widgets

This reference outlines how to add total rows to your table widgets and change the type of total.

Prerequisites

Before you read this reference, perform all of the following actions:

  • Create a simple table widget that contains at least one metric and one dimension. For more information, see Creating tables.

Adding a total row to a table widget

To add a total row to a table widget, follow these steps:

  1. In the platform navigation menu, click Explore.

  2. Select the workspace you work with in Explore & Present.

  3. Click on the view that contains the table widget to which you want to add totals.

  4. Above the table widget, click Total row.

As a result, a total row has been added to your table widget. By default, the type of total is automatically determined.

Changing the type of total in a table widget

To change the type of total in a table widget, follow these steps:

  1. In the platform navigation menu, click Explore.

  2. Select the workspace you work with in Explore & Present.

  3. Click on the view that contains the table widget containing the total you want to change.

  4. In the Metrics panel, click the name of the metric for which you want to change the total. This will open a list of options for this field.

  5. Click ⌖ Total using measure.

  6. In the Select total using measure window, select one of the following:

    • Sum (SUM) displays a sum total of the values in the table for the selected metric.

    • Average (AVG) displays an average of the values in the table for the selected metric.

    • Minimum (MIN) displays the minimum value from the values in the table for the selected metric.

    • Maximum (MAX) displays the maximum value from the values in the table for the selected metric.

    • Count (COUNT) counts the number of values shown in the table for the selected metric.

    • Automatic (AUTO) is the default total type. It automatically determines the type of total depending on the type of metric you select.

    • Hide (HIDE) hides the total value.

  7. Click Apply.

As a result, you have changed the type of total displayed in the table widget.