How to create matrix report to track the assignment group field on incident table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-27-2023 01:12 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-27-2023 01:18 AM
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:
- Navigate to the ServiceNow instance and log in with your credentials.
- Go to the Reports module and click on "Create New."
- Select the "Matrix" report type.
- Provide a meaningful name and description for the report.
- In the "Table" field, select the "Incident" table.
- In the "Available Fields" section, search for and add the following fields:
- Assignment Group
- Old Value
- New Value
- Updated
- Configure the report layout as follows:
- Row: Assignment Group
- Column: Old Value
- Cell Content: Count of New Value
- Sorting: Based on Updated (Descending)
- Apply any additional filters or conditions based on your requirements, such as time range or specific incident states.
- Save the report.
Was this answer helpful?
Please consider marking it correct or helpful.
Your feedback helps us improve!
Thank you!
Regards,
Amit Gujrathi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā05-27-2023 01:32 AM
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