I want to create a matrix report which lists my technicians on the left in rows and the columns on top are broken down into weekly periods (the range may be a year, multiple or a single month with a weekly breakdown). The content is to show how many tickets the technicians raised on a weekly basis. 

The wizard doesn't allow me to group days into weeks, is there a way to do this via an MS SQL query? Fields I'm working with are Created By (filtered on my technicians name because staff can create their own tickets as well) and Created Time. Using Request ID as the count.

Thank you.

Amy