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

[gflewis]

This can only be done by creating a Database View.   You are trying to perform an outer join, and the ServiceNow reporting engine does not perform outer joins.   You will need to create a database view starting with the sys_user_group (grp) and joining to incident (inc) where inc_assignment_group = grp_sys_id.   Be sure to click the "Left join" checkbox on the incident table.

Database Views are described here:   Database Views - ServiceNow Wiki

I think the Database Views plug-in is not installed by default, so you may need to install it.

[kiransnaik]

Wow. Thank you Giles.

I will try it.