Change Aggregation Using the Table Context Menu

Change the aggregation metrics in a table using the table context menu

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. Select next to the column heading name of any metric field in the table to access the table context menu.

   

4. 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. Optionally, select relevant show/hide options for individual labels using the table context menu in the column header.

5. Save the dashboard and visual.