Hello Staff,

I need to create a matrix report which lists: Categories and SubCategories on the left in rows,  and the columns on top are broken down into Year/week. The scope is to show how many tickets (count) are created for each subcategories (and ) on a weekly basis. 

The wizard doesn't allow me to choose neither DateFormat = Year/week or DateFormat = Week

 I was wondering,  is there a way to do this via ServiceDesk Query Report instead of Matrix Report? or could you give me support to build the query?

We have ServiceDesk 8.2  (last minor) installed on MySQL, but in the next two weeks we will move to 9.0 (latest patch) without changing DB.

Thanks in advance

Flavio Salusso