- Go to Reports | Other reports | Export email. This is what to put in for the query:
sum(total_tix) as tickets, sum(total_sale) as sales, left(zip,5) as zip
left join customer using(customer_id)
where today_date >= "201x-xx-xx"
and today_date <= "201x-xx-xx"
group by left(zip,5)
order by zip
- This is what it looks like:
- When the report is run and sent to a spreadsheet, the report looks like this: