This section explains each of the properties in the configuration blade.




This associates the Agent to a specific Collection and defaults to that of the current Data Stream.

Refer to Collections and Stream Hosts to understand more about Collections.

Pivot Column Configuration


Static Columns

The columns or attributes of the input payload by which the pivot column is grouped.

Pivot Column

The column or attribute of the input payload on which the aggregation is applied. A numeric attribute must be used with the Sum Aggregate Type.

Aggregate Type

The aggregation performed on the data in the Pivot Column. The options are:

  • Count: the number of times the value appears

  • Sum: the total value

Include Total Column?

Tick to include a Total attribute in the output payload, which contains the total aggregation for the static columns' unique combination. Applies to Count Aggregate Type only.

Possible Pivot Values

The values which will be pivoted. Eg: The Pivot Column attribute 'Quantity' has Possible Pivot Values 1, 2 and 3. Events in the batch with other values (eg 4) are ignored. The new pivoted attributes' names in the output payload are generated by appending the Pivot Value to the Pivot Column attribute name, eg: Quantity_1. Applies to Count Aggregate Type only.

Pivot Column Prefix

The new pivoted Sum attribute's name in the output payload (defaults to Generated). Applies to Sum Aggregate Type only.

Before configuring the Transformation, please ensure that its input endpoint is connected to a parent Agent which will be sending data to it.




This endpoint is used to receive data from the parent Agent.


Events received from the parent Agent one event per unique combination of the static columns is made available to this endpoint.

The (unchanged) static columns are included in the output payload. New attribute depend on the aggregation type:

  • Sum: A new attribute is added with the name defined in Pivot Column Prefix.

  • Count: One new attribute per possible pivot value in the format {Pivot Column}_{Pivot Value}. Eg: Quantity_1.

There will also be a Total attribute, if Include Total Column is ticked.

Last updated