specs/models/M_TABLE_AGGREGATION
Table Aggregation
Table Aggregations allow users to define common summary functions on any field in a Table.
They are combined with Table Queries within the App Builder so that these aggegation values can react in real-time to changes in the records that are included in the Table Query.
Table Aggregations are saved in their current state with every published version of an app. So, when a new version of an app is created, it cannot be changed by changing the rules of a Table Aggregation.
Table Aggregations can only reference a single Table.
Fields
| Name | Description |
|---|---|
| Name | The name of the Table Aggregation |
| ID | The unique ID of the Table Aggregation |
| Calculation | The summary function that is performed by the Aggregation. Choices include: Sum, Count of Rows, Average, Maximum, Minimum, Mode |
| Field | The field in the Tulip Table that is being referenced |
Tests
| ID | Name |
|---|---|
| QA-T572 | Table Queries : 03 - Create, Edit, Delete an Aggregation |
| QA-T573 | Table Queries : 04 - Aggregation Configuration |
| QA-T703 | Table Queries : 07 - Unique value aggregation |
| QA-T721 | Table Queries : 03 / Can't edit a saved Aggregation without clicking 'Edit' |
Requirements
No requirements