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 

You can create a report on the TAS table, and it should be a pivot-type report.

[Apurva127]

Hi @Dr Atul G- LNG 
Thank for help
Is TAS table means [ TASK ] table

[Apurva127]

Hello @Dr Atul G- LNG 

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

[Dr Atul G- LNG]

Hi @Apurva127 

Create the Multi Pivot type report