Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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.

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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