Incident Reports to generate ticket count based on groups

[amit_kishore]

Hi all 

I have a requirement where I need to show report based on groups of assignment group.

Example : I have 10 groups out of which 5 belongs to vendor. So I have to show the vendor incident count vs rest in group.

[AndersBGS]

Hi @amit_kishore ,

I would recommend you to create a report based on non-vendor incidents. Afterwards, add a dataset according to this documentation: https://docs.servicenow.com/bundle/xanadu-now-intelligence/page/use/reporting/task/t_AddAnAdditional... for vendor incidents.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[Moedeb · Accepted solution]

What I'd suggest is that you create some new assignment groups that will be used as "Parent Groups" 

Eg: 

• My Company 
  • Assignment Group 1
  • Assignment Group 2
  • Assignment Group 3
  • Assignment Group 4
  • Assignment Group 5
• Vendors
  • Assignment Group 6
  • Assignment Group 7
  • Assignment Group 8
  • Assignment Group 9
  • Assignment Group 10

In the groups you want to track go into them and set the appropriate "parent"

Then in your report filter based on the parent assignment groups:

Then group by "Assignment Group >> Parent"