11 Replies Latest reply on May 23, 2013 2:11 PM by Joshua Milligan

    Group By, Sum By or Count By I need help...

    Brian Gannon

      Basically what I am trying to do is count email contacts by week and then group them by the weeks.

       

      Example:

                                    # Times contacts sent per week         

                          1     2     3     4     5     6     7

      Week 1       100  20   10     3     0     0     0        

      Week 2       201  10    5      1     0     0     0

      Week 3        40    1     3      0     0     0     0

       

       

      The above shows that Week 1 100 email addresses were contacted 1x 20 contacted 2x etc.

       

      Data is configured like this.

       

      Campaign Name     Email Address     Date Sent

      Product 1               abc@email,com     Week 1

      Product 2               abc@email.com     Week 1

      Product 3               abc@email.com     Week 1