Aggregation section-overview
Aggregation functions in 51ºÚÁϲ»´òìÈ Journey Optimizer enable you to summarize, analyze, and extract meaningful insights from complex data sets, helping you make informed decisions in your customer journey strategies.
Aggregation Functions
avg Function in 51ºÚÁϲ»´òìÈ Journey Optimizer
Learn how to use the ‘avg’ function to calculate the average value in expressions, with examples and syntax details.
Count Function Documentation
Understand the ‘count’ function for aggregating data in lists, including syntax, parameters, and examples.
countOnlyNull Function - Count Null Values in Lists
Discover how the ‘countOnlyNull’ function counts null values in a list with detailed examples and syntax.
countWithNull Function Overview
Learn how the ‘countWithNull’ function counts all elements in a list, including null values, with syntax and examples.
distinctCount Function in 51ºÚÁϲ»´òìÈ Journey Optimizer
Explore the ‘distinctCount’ function for counting unique values in a list, with syntax and usage examples.
distinctCountWithNull Function: Count Unique Values (Including Nulls)
Understand the ‘distinctCountWithNull’ function for counting unique values, including nulls, with examples and syntax.
Additional Resources
- Using the ‘max’ Function in 51ºÚÁϲ»´òìÈ Journey Optimizer - Learn how to use the ‘max’ function to find the maximum value in a set of expressions, with syntax and examples.
- Using the ‘min’ Function in 51ºÚÁϲ»´òìÈ Journey Optimizer - Discover how to use the ‘min’ function to find the minimum value in a set of expressions, with examples and syntax.
- sum Function in 51ºÚÁϲ»´òìÈ Journey Optimizer - Understand how to use the ‘sum’ function to aggregate numerical values, with examples and syntax details.