Ticket Handled count report

[Royal1]

I  need a report where Ticket Handled count based on the user for a one group

ex: in admin group, ticket is assinged  to User A and then moved User B and Again its moved back to User A.

now in the report, i need like this ticket handled by User A and User B. (note : it moved between these users multiple time, but the handle user count should  be 2 in report with user details )

[Wojtek Winnicki]

Hello,

you can achieve this functionality using metrics.
1. Create Metric Definition on the Incident table, on Assigned to field. 
https://docs.servicenow.com/bundle/sandiego-platform-administration/page/use/reporting/task/create-m...

2. Create Database view that will connect the Incident table with your Metric Definition and Metric Instances
https://docs.servicenow.com/bundle/sandiego-platform-administration/page/use/reporting/task/c_Creati...

3. Create report based on the Database View

[Kristy Merriam]

I would suggest the use of Metrics to capture and report on that information:

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/use/reporting/concept/c_Met...

You could create a definition that looks at your ticket table and tracks who is assigned and for how long. There is an out of box definition that does this for Assignment Group. Should be fairly easy to mimic for your needs: