Group by
Current version v1.0.0
Last updated
Was this helpful?
Current version v1.0.0
Last updated
Was this helpful?
Summarize data by performing aggregations using keys and temporal keys (min, hour or day).
In order to configure this action, you must first link it to a Listener. Go to Building a Pipeline to learn how to link.
These are the input and output ports of this Action:
To open the configuration, click the Action in the canvas and select Configuration.
Enter the required parameters:
Grouping configuration
Fields to Group*
Lists the fields from the linked Listener or Action for you to choose from.
Choose one or more fields to group by.
Grouping time*
Having defined which fields to group by, choose or create a Grouping Time. You can write the amount and unit (seconds, minutes, hours, days), or select a common amount.
Click Save.
Aggregations
Aggregations*
Now you can add aggregation(s) to your grouping using the following operations:
average: calculates the average of the values of each grouping.
count: calculates the total occurrences for each grouping.
countnotnull: calculates the total occurrences for each grouping, excluding null values.
first: finds the first value found for each grouping . The first value will be the first in the workers queue.
firstnotnull: finds the first not null value found for each grouping . The first value will be the first in the workers queue.
ifthenelse: the operation will only be executed if the given conditions are met.
last: finds the last value found for each grouping . The last value will be the last in the workers queue.
lastnotnull: finds the last not null value found for each grouping . The last value will be the last in the workers queue.
max: finds the highest value found.
min: finds the lowest value found.
sum: calculates the total of the values for each grouping.
To add another aggregation, use the Add item option.
You can also use the arrow keys on your keyboard to navigate up and down the list.
Conditions
You can also carry out an advance configuration by Grouping By Conditionals.
Use the Add Condition option to add conditions to your Aggregation.
Click Save to complete
In this example, we will use the Group By action to summarize a large amount of data, grouping by IP address every 5 minutes and aggregate the number of requests by type per IP address.