reports graph combine query

select
	report.report_date,
	sum(report.new_users) sum_new_users,
	sum(report.active_users) sum_active_users,
	sum(report.sessions) sum_sessions,
	sum(report.total_minutes) sum_total_minutes
from report_by_did_2015_1 report
	inner join data_entryway de on report.entryway_id = de.id
	inner join data_gateway dg on de.gateway_id = dg.id
where report.report_date >= '2015-03-01'
	and report.report_date <= '2015-03-31'
	and dg.id in (<gateway_ids>)
	and de.did_e164 = <did>
group by report.report_date