ServiceNow REPORTS

[Apurva127]

In ServiceNow I want report like following,

the sum of number of Incidents, SC Tasks, and Change Requests assigned per Assignment Group (only ITIL group we want in report)
if 0 record is also there then show that in reports.

something like following:

Assignment Group              Incidents       SCTASKs       Changes        TOTAL SUM
               A                                           3                 4                          6                       13
              B                                            4                 5                         2                        11
              C                                           0                 0                          0                       0
              D                                          10              20                         30                     60

How can we achieve this report.
Please give me solution & detailed steps for this.

[Dr Atul G- LNG]

Hi @Apurva127 

[Shruti D]

Hello @Apurva127 ,

Please refer the below Links:
Multilevel pivot Reports 
Pivot tables Report 
How to Create a Report in ServiceNow: A Step-by-Step Guide 

Please Mark Correct ✔️ if this solves your query and also mark Helpful 👍 if you find my response worthy based on the impact.

Regards,
Shruti

[Apurva127]

Hello @Shruti D 

Thank you .

I tried with this but it is not giving data for assignment group with 0 record for all (incident , change ,scTask ) like Group C in given question.

please help here

[Bhuvan]

@Apurva127 

Create report as below,

Table : task

Filter Conditions -> Task Type is Incident or Catalog Task or Change Request [change it as per requirements]

Report Type : Multi-level Pivot Table

As per community guidelines, you can accept more than one answer as accepted solution. If my response helped to guide you or answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Apurva127]

HELLO @Bhuvan  @Dr Atul G- LNG @Shruti D 

if count is zero for any group  then that group also i want it in report.
how this I can achieve .

please help