# Rollup Column

{% embed url="<https://www.youtube.com/watch?v=HBrF6wAMghA&list=PLSkzi9eq0vBnUGMnwXrRRVo9TXUjZ7uSj&index=22&ab_channel=JetAdmin>" %}

The roll-up allows you to perform a calculation on [Relation](https://docs.jetadmin.io/user-guide/computed-columns/relations). 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:

1. Click on `Add New Column` Icon
2. Choose `Rollup-Related Records`
3. Choose `Properties`
4. Select `aggregate properties`
5. Click to **Save** it

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

### Column or relation source <a href="#column-or-relation-source" id="column-or-relation-source"></a>

![](https://3448227606-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-LQ08RFAKZvFADEiXKFy%2Fuploads%2FlKr2guhyEwpiMBdgdGla%2Fimage.png?alt=media\&token=fa88eadb-b81f-4e01-9039-6589b90a8780)

### Calculations <a href="#calculations" id="calculations"></a>

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

#### Numbers <a href="#numbers" id="numbers"></a>

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.

#### Dates <a href="#dates" id="dates"></a>

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.

#### Boolean <a href="#boolean" id="boolean"></a>

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.

#### Text <a href="#text" id="text"></a>

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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.jetadmin.io/user-guide/computed-columns/rollup-column.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.