Aggregation options in event strategies
You can aggregate values of event properties to derive such insights as sum, count, standard deviation, or median. By looking at the aggregated data, you can detect meaningful patterns that can help you optimize your next-best-action offering.
You can select any of the following aggregation options, depending on your business use case:
- Average
- Returns the average value of the specified property for the collected events.
- Count
- Returns the total number of collected events for the specified property.
- Distinct Count
- Returns the number of unique values of the specified property for the
collected events. This function counts the
NULL
value as a unique value. - First
- Returns the value of the first event in the window for the specified property.
- Last
- Returns the value of the last event in the window for the specified property.
- Max
- Returns the highest value of the specified property for the collected events.
- Approximate Median
- Returns the median value of the specified property for the collected
events.
- Depends on value distribution – By default, the approximate median converges with the actual middle value a set speed every time a new event arrives at the window, depending on the value distribution.
- Custom speed – You can control the speed of convergence by entering a custom value, which must be a positive number. By using this mode, you can converge with the actual median faster or slower, depending on your business needs. If you increase the speed of convergence, the calculated approximate median might be less accurate. If you decrease the speed of convergence, the median might be more accurate, but it takes more time to converge.
You define the convergence speed mode by clicking the
Open icon to: - Min
- Returns the lowest value of the specified property for the collected events.
- Sum
- Adds the values of the specified property for the collected events and returns the sum.
- Standard Deviation
- Returns the standard deviation of the specified property for the collected events.
- True if All
- Returns
TRUE
when all values of the specified property areTRUE
. - True if Any
- Returns
TRUE
when at least one value of the specified property isTRUE
. - True if None
- Returns
TRUE
when all values of the specified property areFALSE
.
Previous topic Adding aggregations in event strategies Next topic Approximate median calculation