Monthly Report - Closed and opened requests
Hello!
I am somewhat capable when it comes to simple queries, but working with multiple joins, etc, I start to get lost.
I am looking for a monthly report that produces the following for <Last_Month>:
---------------------------------------------------------
| Site | Category | # Opened | # Closed |
---------------------------------------------------------
This report could group based on Site and Category to produce a matrix, or it could just be a tabular report. Any help would be greatly appreciated!
I am somewhat capable when it comes to simple queries, but working with multiple joins, etc, I start to get lost.
I am looking for a monthly report that produces the following for <Last_Month>:
---------------------------------------------------------
| Site | Category | # Opened | # Closed |
---------------------------------------------------------
This report could group based on Site and Category to produce a matrix, or it could just be a tabular report. Any help would be greatly appreciated!