How to create matrix report to track the assignment group field on incident table

VIKAS MISHRA
Tera Contributor

I want to create on matrix report where i can track the assignment gorup field of incident table 

i want to see the old and new value of the field andd time also like in which gropup it stayed for how long.

I hope there is one matrix report can be created on this, please suggest how

2 REPLIES 2

Amit Gujarathi
Giga Sage
Giga Sage

HI @VIKAS MISHRA ,
I trust you are doing great.

To create a matrix report in ServiceNow to track the assignment group field of the Incident table, follow these steps:

  1. Navigate to the ServiceNow instance and log in with your credentials.
  2. Go to the Reports module and click on "Create New."
  3. Select the "Matrix" report type.
  4. Provide a meaningful name and description for the report.
  5. In the "Table" field, select the "Incident" table.
  6. In the "Available Fields" section, search for and add the following fields:
    • Assignment Group
    • Old Value
    • New Value
    • Updated
  7. Configure the report layout as follows:
    • Row: Assignment Group
    • Column: Old Value
    • Cell Content: Count of New Value
    • Sorting: Based on Updated (Descending)
  8. Apply any additional filters or conditions based on your requirements, such as time range or specific incident states.
  9. Save the report.

Was this answer helpful?


Please consider marking it correct or helpful.


Your feedback helps us improve!


Thank you!


Regards,


Amit Gujrathi



Thanks for your reply but i can not see the report type as matrix, when i am searching for matrix report type then its only showing the report type "Heatmap" but not matrix