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

Returning results including rows with 0 incidents for the month

Received Response
10
Views
2
Comments
edited May 22, 2018 3:31PM in Reporting & Analytics for B2C Service 2 comments

Content

I have a report which is summing up incidents based on items in a custom drop down field. I can't show you the actual results because of confidential data.  But essentially, the issue types in the drop down are how I am summing up the count of incidents for the month.

There are about 60 items in the drop down list on the form that is used to submit these incidents.  In any given month, I don't expect to have all of these items used.  But for consistency across months when these are exported to Excel and combined with previous months in various ways, I would like to return a row for each of the 60 items whether there was an incident for that item that month or not.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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