A rollup field in Baserow allows you to aggregate data and gain valuable insights from linked tables. It performs calculations on rows from a linked table.
A rollup field performs calculations with the linked values. For example, it can sum together all the values from the linked rows or return only the maximum value.
The rollup field can only be used when you have a link to table field in your table. To use a rollup field, create a link to table field that’s linked to another table in your database.
To add a rollup field to your table:
+
button located on the far-right side of the table to add a new field.After configuring these options, the rollup field will calculate the specified value based on the linked table’s data.
To change the field title or link to table field of an existing rollup field, click on the dropdown next to the field and edit the details.
Rollup functions are calculations that can be performed on the values from the linked table. Baserow provides several functions that can apply, including:
any
: Returns true if any one of the values from the linked rows is true, or false if any one of the values is false.every
: Returns true if all values from the linked rows are true, or false if all the values are false.max
: Returns the maximum value from the linked rows.min
: Returns the minimum value from the linked rows.count
: Returns the number of items in its first argument.avg
: Returns the average of all the values from the linked rows.sum
: Returns the sum of all the values from the linked rows.stddev_pop
: Returns the population standard deviation of the values from the linked rows. The population standard deviation should be used when the provided values contain a value for every single piece of data in the population.stddev_sample
: Returns the sample standard deviation of the values from the linked rows. The sample deviation should be used when the provided values are only for a sample or subset of values for an underlying population.variance_pop
: Returns the population variance of the values from the linked rows. The population variance should be used when the provided values contain a value for every single piece of data in the population.variance_sample
: Returns the sample variance of the values from the linked rows. The sample variance should be used when the provided values are only for a sample or subset of values for an underlying population.Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions—we’re ready to assist you.
Contact support for questions about Baserow or help with your account.