How do I make a report show empty values?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2018 10:33 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2018 01:00 PM
Have you tried a view based on sys_user with a left join to incident?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2018 01:19 PM

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2018 01:49 PM
If they don't have anything it's empty which you're filtering out.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2018 01:53 PM
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!