Column Type - Aggregation

Avatar

By Rachit

updated 7 days ago

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?