reports graph active users

select
	report.report_date,
	sum(report.active_users) sum_active_users
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.gateway_id in (<gateway_ids>)
	and de.entryway_id = <did>
group by report.report_date