Report previous day

Hey @rcrichton mind taking a quick look at this for me? Do the queries look okay to you?