description
Perform calculations on columns or relations like count, average, and sum.

Rollup Column

The roll-up allows you to perform a calculation on Relation. The most basic computation for the rollup is Count.

For example, in the image below we create a rollup column that counts the number of items in the Properties column. To do so, follow the steps:

{% @arcade/embed flowId="gQzmHDhkawUy8SsIbOu1" url="https://app.arcade.software/share/gQzmHDhkawUy8SsIbOu1" %}

The Rollup Column can perform different calculations based on the data it finds in the column or relation you select.

When performing a rollup on numbers, the Rollup Column can execute various calculations to derive meaningful insights.

Sum: Aggregates the total sum of numbers in the specified column or relation.
Average (Mean): Computes the average of the numbers within the chosen column or relation.
Minimum (Min): Identifies the smallest number in the specified data.
Maximum (Max): Determines the largest number found in the chosen column or relation.

When dealing with date-related information, the Rollup Column can provide insightful calculations:

Earliest Date: Identifies the earliest date within the selected column or relation.
Latest Date: Determines the most recent date present in the specified data.
Time Range: Calculates the duration or period between the earliest and latest dates.
Average Duration: Computes the average time duration between date values.

For Boolean data, the Rollup Column can offer meaningful computations:

Count of True/False: Determines the number of true or false value occurrences in the chosen column or relation.

When working with text-based information, the Rollup Column can be employed for diverse calculations:

Concatenation: Combines text values into a single string, facilitating further analysis.
Length of Text: Measures the character length of each text entry.

Provide feedback