Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

Info

Learn more about Concat rollup type here

Count

Calculates the total number of records.

Count Distinct

Counts the number of unique records.

Sum

Adds up the values of

List

Generates a list of all values in the selected field, separated by a delimiter.

Info

Learn more about List rollup type here

Maximum

Identifies the highest value in the selected field.

Minimum

Identifies the lowest value in the selected field.

Average

Sum

Calculates

Adds up the

average

values of

the values in

the selected field.