(v24) Change Aggregation Using the Table Settings Sidebar

Change Aggregation Using the Table Settings Sidebar

This applies to: Visual Data Discovery

Change the aggregation of metrics in a table using the Table Settings sidebar

1. Edit a dashboard with a table that uses a data source containing metric fields.

2. Group the table. See Group and Ungroup Table Data.

3. If you are viewing the table in a dashboard, select Settings from the visual drop-down menu. The sidebar menu for the visual appears.

   If you are viewing the visual from the Visual Gallery, the sidebar appears to the right of the visual.

4. Select on the sidebar menu. The Table Settings sidebar for the visual appears.

   

5. In any of the metric fields in the Columns section of the sidebar, select the aggregation method you want. Possible aggregation methods include None, Avg, Min, Max, Sum, Last Value, Count, and Distinct Count. For information about aggregation methods, see Metric Aggregation Functions.

   The selected aggregation method is applied to the metric.

6. Select Apply to apply your changes to the table.

7. Save the dashboard and visual.