How can I see assignees with no / zero tickets?

[Mads Jensen]

I have a group with many assignees.
I want to show which assignees (users) who have no (zero) tickets (incidents).

- I have tried both tables (incidents and members). 

[cdealmeidacalde]

Hi mads, have you tried to report on the incident table, set the condition to include only incidents for that group?

You could use a bar chart visual and group by the assigned to field, it will show you all the members of the group and how many records are assigned to each one 

[Mads Jensen]

I only shows members with records. Not members without records.

[David Nendza · Accepted solution]

There are multiple ways of doing this, but for a simple, quick report, I'd probably do a report based on the sys_user with the conditions:
user ID is one of [list of users from the group]
Then in the RELATED LIST CONDITONS, change the condition to None, No selected table records are related to a record on User [Incident ->Assigned to].  
Add any further conditions you want to check on the incident table, like active=true to have it only look at active incidents.
This should return the users that don't have any matching tickets on the incident table.

You could also probably create some fancy database view, but my brain is too tired to figure out the joins atm

[Mads Jensen]

Thank you so much for the workaround.

Unfortunately, I have to manually update their name. There is no "Group"-option.