Skip to main content

Get help for ARIS

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. Procedure

  1. Add a Grid widget to the dashboard.

  2. Assign a data source to the widget.

  3. Add at least one numerical column to the Grid widget.

    1. On the Setup panel of the widget, click Add columns > Standard columns. The Grid columns panel opens.

    2. Select a numerical column.

    3. Click Done. The selected column is added to the Setup panel.

  4. On the Setup panel of the widget, click the Configure averageTotal aggregation icon of a numerical measure. The corresponding panel opens to configure the 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.

Example 141.

The table in the example contains the text column ARTIST the numerical column PRICE and shows the average value of the column in the bottom row.

Value aggregation