You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report to count responses but include incidents with no responses

Summary:

I need a report that shows all the incidents with a count of responses for the ones that have responses, but includes those incidents that don't have responses

Content (please ensure you mask any confidential information):

I have a report of incidents to show the current status of all of the incidents for a team. They want to add a column that shows the number of responses to each incident to date. I can get a report that only shows incidents that have been responded to using a filter on the transactions.trans_type to be Response Sent. But when I add the transaction type of None to that filter, I don't get the incidents that have also had no responses, I still only get the incidents that have had a response. I need to

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!