Display aggregated values in tables

You can display aggregated values, that is average, total, and count values for each measure in a table. The values are displayed in the last row of the corresponding columns.

Procedure

  1. Add a Grid widget to the dashboard, for example.

  2. Assign a data source to the widget.

  3. Add at least one measure to the widget.

  4. On the Setup (Configuration) panel of the widget, click the Configure average Total aggregation icon of a measure. The corresponding panel opens to configure the value aggregation.

    Example

    The table in the example contains a column Price and shows in the bottom row the average value of the column.

    Value aggregation

  5. Enable Show to display the aggregated value in the table.

  6. Select the aggregation type in the Type drop-down menu.

  7. Select the color for the values displayed in the table.

  8. Click Done.

The aggregated column value is displayed in the table.