Calculate an entire column or relation

The rollup allows you to perform a calculation on an entire column or a 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 `Animals`

column.

You can perform a calculation on values in a column or a relation column. For example, in the app below we have a list of users with a relation

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

Numbers

Dates

Boolean

Text

Numbers

The rollup column can calculate the `Count`

, `Count Unique`

, `Sum`

, `Average`

, `Range`

, `Minimum`

and `Maximum`

of number values in a column or relation.

Dates

The rollup column can calculate the `Count`

, `Count Unique`

, `Earliest`

and `Latest`

of date values in a column or relation.

Boolean

The rollup column can calculate the `Count`

, `Count Unique`

, `Count True`

, `Count False`

, `All True`

, `Some True`

Text

The rollup column can calculate `Count`

or `Count Unique`

You can use the rollup in many ways. Tru (one of our engineers) used it to create a handy recipe app that tells her the recipes she can make with the ingredients she has. https://food-template.glideapp.io/

Our expense splitter template also uses the rollup column to calculate the `Sum`

& `Count`

of different columns. https://go.glideapps.com/app/expense-splitter-template