Grouping counts by date

[berryandcherry6]

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

[neha_shirsath]

Can you send some sample data?

Or probably you can force concatenate all 4 tables and create master calendar.

Or depends on requirement you can create link table with common fields and date and link this date to your Master Calendar.

[berryandcherry6]

Hi neha,

i have attached sample app. Please look into it.

[neha_shirsath]

Hi,

Attachment missing. Can you please attach it again.

[berryandcherry6]

Please find attached app