Configuration

This section explains each of the properties in the configuration blade. 
General
Property
Description
Collection
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
Property
Description
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.
Endpoints
Name
Description
Input
This endpoint is used to receive data from the parent Agent.
Output
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.

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

Property	Description
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.

Name	Description
Input	This endpoint is used to receive data from the parent Agent.
Output	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 modified 1yr ago