Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

I want a report which shows the the top 10 tickets creators(both incident and request) along with the count in a single report. any suggestions?

v_austin
Kilo Contributor

I want a report which shows the the top 10 tickets creators(both incident and request) along with the count in   a single report. any suggestions?

1 ACCEPTED SOLUTION

traceymaycock
ServiceNow Employee
ServiceNow Employee

Hi Vidhya,



You can do something like the following:



Table = Task


Type = Bar


Group By = Created By


Number of Groups = 10


Uncheck show other



Filter:


Task Type is incident


OR


Task Type is Request



Hope this helps.



Kind regards



Tracey


View solution in original post

2 REPLIES 2

Gaurav Bajaj
Mega Sage

Hi Vidya



I don't think you can add multiple table's data in one report.


Better create a dynamic block and add it your homepages.



http://wiki.servicenow.com/index.php?title=Using_Content_Blocks#Dynamic_Blocks&gsc.tab=0



Thanks


Gaurav


traceymaycock
ServiceNow Employee
ServiceNow Employee

Hi Vidhya,



You can do something like the following:



Table = Task


Type = Bar


Group By = Created By


Number of Groups = 10


Uncheck show other



Filter:


Task Type is incident


OR


Task Type is Request



Hope this helps.



Kind regards



Tracey