How do I make a report show empty values?

Evan S
Kilo Contributor

I wrote a report (a bar chart) that shows all the Incidents and Tasks assigned to technicians in my group.  However, if any of them do not presently have an assignment, their name doesn't appear on the report. 

How can I force the report to show all technicians in the group, even if they presently have 0 assignments?

8 REPLIES 8

Adam Stout
ServiceNow Employee
ServiceNow Employee

 

Have you tried a view based on sys_user with a left join to incident?

Evan S
Kilo Contributor

How do I do that?

 

I've attached the current report settings I'm using.

ServiceNowSteve
Giga Guru

If they don't have anything it's empty which you're filtering out.

Allen Andreas
Administrator
Administrator

You wouldn't filter anything off the user then. It will then pull everyone regardless of empty or not.

Remove both assigned_to conditions.


Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!