How do I make a report show empty values?

[Evan S]

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?

[Evan S]

I tried that - it's now showing me unassigned tickets (and tickets assigned to someone I don't want to see on the report).  What I want is a blank spot in the graph for a technician that's in our group, but currently has no tickets.

[Allen Andreas]

I understand. Please do something like this:

Essentially, group by: assignment group, stacked by assigned to and then bubble in grouped columns. Conditions are assignment group is Deployments and then active is true.

That will show you all members in that group and there is NO condition to filter out anyone who doesn't have a task, BUT it will show them all. Like who currently has what.

[Evan S]

Thanks.  I just tried it exactly like you said, but the graph is still only showing me the 9 techs that have active Incidents, not all 17 techs in the group.

[Adam Stout]

You can't filter on the incident table since that doesn't have the record you are looking for (people without incidents).  For this case, you need a view. 

You could also look at PA as the breakdowns handle 0 values.  You could also use a related list condition to get those in the group with no incidents, but that would not be in the same chart (although perhaps you could do it with multiple data sets.