4 Replies Latest reply: Dec 7, 2017 11:31 PM by Supriya R RSS

    Grouping counts by date

    Supriya R

      Hi,

       

      i have a requirement where i need to get counts for sent,delievred,opens,clicks, bounce, unsubscribe each date in Table.

       

      Days               opens     clicks  delievred sent

      28/10/2017        3             3         5          5

      29/10/2017        1             0         6           8

      30/10/2017        13           10         22         34

      01/12/2017        2              1        4            4

      02/12/2017        4              3         6           7

      03/12/2017        6              5         6           6

       

      Here dimension rows increases day by day because it is dynamic  takes every day date.

       

      i have 3 tables with fields and different datecreated

       

      Table1:

      invitation_id,

      client_id,

      batch_id,

      campaign_id,

      language_id,

      sent,

      date_created

      from table1:

       

       

      Table2:

      invitation_id,

      track_type,

      date_created

      from table2:

       

       

      Table3:

      invitation_id,

      bounce,

      unsubscribe,

      date_created

      from table3:

       

       

      Table4:

      id,

      track_type

      from table4;// track_type=1 is opened,track_type=2 is clicked

       

      here for each date i want to show counts  by  date_created and campaign_id.

      i have posted sample app below in discussion.PLease refer

       

      How could i do this? Please help me on this