Assignment groups with No(Zero) Incidents are not reflected in the report

[kiransnaik]

Hi,

I have created the report with these conditions.

Table: Incident

Type: Bar Chart
Group By: Assignment Group

Aggregation: Count

Chart Size: Small

Display Grid: Ticked (YES)

Other Threshold: Show all

Show empty columns: Ticked (Yes)

Filter conditions:

Assignment Group is A1 or

Assignment Group is A2 or

Assignment Group is A3 or

Assignment Group is A4 or

AND

Crated Between 2014-XXXXXX to 2014-XXXXXX

My Results shows only for two Assignment Groups which have incidents created. But not for others which do not have any Incidents created in that date range.

I am expecting that even there are no Incidents for Assignment group, that should also be visible in the Bar Chart as Zero.

Is this possible. Your input is greatly appreciated.

Thank you,

Kiran

[Ajai S Nair]

Hi Kiran,

As the condition for date range is given in AND condition, the assignment group without incidents wont be shown if I am not wrong.

This link will help you in creating bar charts: Creating Bar Charts - ServiceNow Wiki

Thanks and Regards,

Ajai

[kiransnaik]

Hi Ajai,

Thank you for the information. Tried but may be something different need to be done.

Looking for the solution.

Thank you,

Kiran

[Kalaiarasan Pus]

you may try using a pivot table type and check.... but if not even a single row is returned for the condition, it will be skipped from display....

[kiransnaik]

Thank you Kalaiarasan..

Yes. I tried. But no luck. As you mentioned, even that got skipped from display:(

Trying to figure out..

Thank you,

Kiran