Skip to content
  • There are no suggestions because the search field is empty.

What aggregations are possible for different types of values at the end of lists?

Effortlessly analyze and summarize data in your List to gain valuable insights from your portfolio data.

At the foundation of your List lies the aggregation layer that is always visible at the bottom of the List. This layer compiles and summarizes data, making it easy for you to visually understand all your data. 

Default Aggregation Types

Number fields

For number fields the default aggregation type is Average. This method provides a quick way to get the mean value of the numbers present in the List. There are also the following aggregation types available:

  • Sum: Aggregates the sum of all numbers.
  • Min: Aggregates the minimum value.
  • Max: Aggregates the maximum value.
  • Average: Aggregates the average of all numbers. 

Users

When dealing with user fields the default aggregation type is Sum. This aggregates the total count of (unique) users.

How to change aggregation types

Follow these steps to change the aggregation type for the specific column/field you are interested in:

  1. Click on the aggregation field to open the aggregation-type menu.
  2. Within the menu, you see all available aggregation types for that field. Select the one that best suits your analytical needs.

Turning off aggregation

Sometimes you may want to view your data without any aggregation.

For each aggregation option there is a None option available. Select None to turn off aggregation for a specific field.

Follow the steps described under How to change aggregation types to turn the aggregation on again.