I'm trying to put together a matrix report which gives dates along one axis and has requests grouped by first incident vs service request and then request status.  The problem is that the field that dictates whether it's an incident or service request (the IS_CATALOG_TEMPLATE field in the database's WORKORDER table) doesn't seem to be in any of the drop-down lists.  I would like to go in and edit the query behind the matrix report, but when you click on "show query" and then "open with query editor" it seems to think you want to create a new tabular report.

It looks like someone else has tried to do this in  https://resources.manageengine.com/topic/summary-matrix-report-query-change but they didn't get back to the SDP employee who was offering to help.

Any help appreciated!  Thanks,

Sam