Incidents assigned to different users.
Content
I am trying to create a report that would show all Incidents from a specific Q (they don't need to stay in the same Q) that were assigned by specific people to other agents.
I got so far as to get all incidents that were assigned from specific Q by specific people, but am struggling how to filter out the ones that they assigned to themselves (either before reassigning, or to resolve). I just want to see the ones that they assigned to other agents.
I hope someone can help. I am attaching the definition in xml and pdf format of what I got so far - as you can see I even managed to get a column that shows No Value if they assigned to themselves, but I would like to be able to filter out these incidents (transactions.acct_id NOT EQUALS accounts2.full_name). Unfortunately, the accounts2.full_name does not allow usage as a filter.