Aggregation Custom Value

aggregation is a type of custom values that enables the users to aggregate multiple values of a data extension/data view that include sum also known as sum in sql average also known as avg in sql count also known as count in sql minimum also known as min in sql maximum also known as max in sql aggregation is supported in two modes basic mode you can use the basic aggregation when you have a predefined relation between the des see this article to learn more advanced mode you need to use advanced aggregation when you don’t have a predefined relation? see this article to learn more watch this video to learn more about aggregation custom value how to create an aggregation custom value? go to custom values section > add new value button provide a name for the custom value > aggregation > click next on the aggregation function , choose the type of aggregation you want to use on the field , select the field that you want to aggregate on 5 in case you have additional filters on this specific aggregation, click edit filters a modal will pop up and you can create the conditions that you want to apply > click save save and drag and drop the new custom value to the target data extension fields scenario you want to get all customer information, along with the number of orders they placed follow these https //support deselect com/hc/en us/articles/360017699917 to achieve this you can also create reusable custom values follow this link to learn https //support deselect com/hc/en us/search/click?data=bah7djohawrskwgrqi9%2fjgo6d2fjy291bnrfawrpa8uyktojdhlwzukidgfydgljbgugogzfvdoidxjsssjxahr0chm6ly9zdxbwb3j0lmrlc2vszwn0lmnvbs9oyy9lbi11cy9hcnrpy2xlcy8xmte2mdq1odg2nte2os1dyw4tss1yzxvzzs1tes1ddxn0b20tvmfsdwvzlwlulwfues1tzwxly3rpb24tbjsivdooc2vhcmnox2lkssipzjhlmdrhzwityjk3ns00zjm1lwfiytgtytm5mtk4ngfkmdnhbjsirjojcmfua2kgogtsb2nhbgvjigplbi11cwy7cfq6cnf1zxj5ssiry3vzdg9tihzhbhvlbjsivdoscmvzdwx0c19jb3vudglb 8d89b0696ecc8e9fbc9296d7434db1983a4f6f07