5 Replies Latest reply: Aug 18, 2017 5:18 AM by Chanty 4u RSS

    expression to get sum for different campaign/record

    Supriya R

      Hi,

       

      i have a table like below

       

      campaign_id clientId  batchMetaDataId       campaignName         startDate     expirationDate

      23                       67                78                  campaignName1       8/15/2017       8/27/2017

      24                       67                78                 campaignName2        8/8/2017         8/20/2017

      29                      67                78                 campaignName8       8/1/2017          8/13/2017

      24                      67                 78                 campaignName3        8/15/2017        8/27/2017

      26                     67                   91                 campaignName4        8/8/2017         8/20/2017

      27                       67                  92                 campaignName5       8/15/2017        8/27/2017

      28                       67                   9 1                 campaignName6      8/8/2017         8/20/2017

      30                      67                   9 1              campaignName9       7/25/2017        8/6/2017

       

       

      To calculate sum of sent counts for all active campaigns by using below code

       

      Sum({$<batch_meta_data_id={'78','91'},expiration_date = {"$(='>=' & Date(Today(),'MM-DD-YYYY'))"},comm_type_id={'44'}>}sent)

       

      But now i want to find sum of counts for each active campaigns separately, how could i do this? let me know if anyone need more info on this.