How to build a report that shows all work assigned to me

morrowc
Kilo Expert

Looking to build a report (if there isn't already one available) that will show quantity of tickets assigned to me (incidents and tasks) per month so that I can see a historical trend.   Any assistance provided will be greatly appreciated.

5 REPLIES 5

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Chris,



You can create a report with the condition as


Assigned to is javascript:getMyAssignments()


Please find the screenshot attached for reference.


Screen Shot 2015-07-14 at 10.38.48 PM.JPG


Thanks for the quick response.   I have created a report that shows all work for all techs within a specified group, but now I'd like to see a historical view that shows on average how many tickets are being assigned to each technician.   Could you please provide suggestions on how to accomplish this?


You'll want a report of type "Trend".


Trend by "Created' per Month (or whatever interval you prefer)
Aggregations hould be "Count"


No.Groups should be "Show all"



Then you add your criteria.   If you're not already filtering the assigned to, you could try grouping by Assigned To and that will cause each bar to have stacks.   Combine that with Display Grid = True and you'll get hte hard numbers as well as the visuals.


I'd also like to have a report that will show me on average how many tickets each tech is resolving/closing each month historically.   Could you please help me with this one as well?