Aggregation summarizes and brings aggregate numerical and other values from linked tables. Right now, the aggregation column type brings only numerical values. In this article, we will cover the following:

Pre-Requisite to configuring an Aggregation Column Type

Types of Aggregation Operations that you can do on Stackby

How to Configure an Aggregation Column Type?

Pre-Requisite for configuring an Aggregation Column Type

There is a pre-requisite for configuring an aggregate column type. You need to link the table that you want to bring information from. 

Note: 

You can only create an aggregate of the 'Number column type' in the linked records table.

Types of Aggregation Operations That You Can Do on Stackby

Currently, you can do 4 types of aggregation operations on Stackby -- all of them numeric. These are:

  • MAX: Returns the largest of the given values
  • MIN: Returns the smallest of the given values
  • SUM: Sum of the values
  • AVERAGE: Returns the average of the sum of values

How to Configure an Aggregation Column Type?

Here's how to configure an aggregation once you have linked your tables:

  • Select a column and then select Aggregation as the column type

Below that:

  • Select the column on the current table to rows you want to aggregate
  • Then select a column from the linked rows from the table that you to summarize or bring the data
  • Now, select the type of aggregation that you want to do -- maximum, sum, minimum or average
  • Then select the formatting -- whether you need the data in decimals, integer, currency or percentage
  • Apply to bring in data

Did this answer your question?