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

How to include a count of 0 value in my report.

Received Response
7
Views
8
Comments
edited May 1, 2018 1:45AM in Reporting & Analytics for B2C Service 8 comments

Content

I am trying to build a very basic report to set up alerts off of, but struggling with getting values of 0 to show in the report to trigger my alert.

The two columns I have are incidents.interface_id and count(incidents.i_id).  When I run the report I want it to show how many emails are on each interface filtered by the create date, but currently when I run the report if there are no incidents on that interface then the line item just doesn't show up.   I want the interface id to show up with a 0 if there are none.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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