You could also fetch in the data as-is without aggregating the data in a load script and then do a simple aggregation with sums in a visualization table in the app:
Date( Floor(Days) ) AS Days,
In a table in a sheet you would:
Add Days as dimension and Sum(opens) in a measure and then Sum(clicks) in a measure.
yes your approch works for me only if sent,delievred,opens,clicks, bounce, unsubscribe fields are all in one table.
What if i have 3 tables with fields and differnt datecreated
from table4;// track_type=1 is opened,track_type=2 is clicked
here for each date i want to show counts by campaign_id, batch_id, date_created,language_id;
How could i do this?