In this section, by clicking on Add Rollup button users can create as many rollup actions as they want within the hierarchy after it's created.
Rollup type specifies the aggregate operators you can use when creating a rollup. PWR Rollup offers various aggregate operators:
Rollup Type | Description | ||
|---|---|---|---|
Average | Calculates the average of the values in the selected field. | ||
Concat | Combines the values of the selected field into a single, concatenated string.
| ||
Count | Calculates the total number of records. | ||
Count Distinct | Counts the number of unique records. | ||
List | Generates a list of all values in the selected field, separated by a delimiter.
| ||
Maximum | Identifies the highest value in the selected field. user can add additional mappings to help to better understand the maximum value in relation to other data.
| ||
Minimum | Identifies the lowest value in the selected field.
| ||
Sum | Adds up the values of the selected field. |