dashboard reports

select
	report.report_date,
	weekday(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
where report.report_date >= '2015-03-01'
	and report.report_date <= '2015-03-31'
	and de.gateway_id in (<gateway_ids>)
group by report.report_date