I was tasks with creating a report to state how many open requests (any request that isn't closed or resolved) with in a certain time frame.  The issue I'm running into is when I create a Matrix report off of Request Status, I can generate a report with a bar graph that breaks out how many open requests of each status we have which is exactly what we want.  The issue is if I wanted to find out how many open requests there were last week Tuesday I can't pull that data due to having to specify a field to filter by, IE Creation Date, Closure Date.

It looks like I may be able to accomplish this task using a custom query but I don't know how to proceed.  Any help to get me on the right track would be greatly appreciated it.

Thank you,

Garrett