How to use functions like COUNT(), AVG(), SUM(), MAX() and MIN() in DESelect Segment?

Question: Can you use functions like COUNT(), AVG(), SUM(), MAX(), and MIN() in DESelect Segment?

Answer: Yes, you can use those functions in formulas when you create subqueries with DESelect Segment. The following Aggregations are supported in DESelect Segment: 

• COUNT: count the number of records where there is a value for a field
• SUM: sums up the values of a field over multiple records
• MIN: take the lowest value of a field over multiple records
• MAX: take the highest value of a field over multiple records
• AVG: take the average value of a field over multiple records

For example, you want to send a voucher to contacts that have bought for more than 100 dollars in the last 2 months.

Here you can find out how to do that using the above-mentioned functions in DESelect Segment: DESelect December ’19 Release: Aggregations and more.