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 https //deselect io/deselect december 19 release aggregations and more/