specs/models/M_TABLE_AGGREGATION
Table Aggregation
Table Aggregations allow users to summarize any field in a Table.
They are combined with Table Queries within the App Builder so that these aggregation 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: Average, Count, Max, Min, Mode, Sum, Unique Values |
| 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-T595 | Table Queries : 08 - Editing and Deleting Queries, Aggregations in Published and Development Version Apps |
| QA-T703 | Table Queries : 07 - Unique value aggregation |
| QA-T721 | Table Queries : 03 / Can't edit a saved Aggregation without clicking 'Edit' |
| QA-T782 | Table Queries : 09 - Multiple table aggregations in one app |
Requirements
No requirements